Last updated 28 January 2025

Data Share and Snowflake Credits

As an administrator, you can now view and access data uploaded to the Snowflake warehouse, via the Data Share feature in IRIS Central.

This feature has been designed to make reporting and analytics more accessible and easier to understand by presenting data through simplified views.

This means you can view and build the reports you need without the complexity of the underlying data.

Using Snowflake Credits to Access Data Share

When you use the Data Share feature, you will need to use credits to pay for the processing time used to query data from the Snowflake warehouse.

These credits are used for the time and resources required to process, store, and manage data within the Snowflake platform. Credits are consumed based on the number of virtual warehouses used to process your data, as well as their running time and their size.

A Snowflake credit is equal to one hour of usage, with a minimum requirement of one minute. However, after one minute of inactivity, data processing will automatically be suspended and your Snowflake credit(s) will not be used.

The amount of Snowflake credits you use depends on how much computing power and resources you need.

If you are using Power BI or other analytics packages, you can import datasets before developing dashboards to avoid using credits, when not needed.

For more information on compute costs and Snowflake, please visit the Snowflake Documentation centre.

Accessing Data Share

Once the Data Share has been enabled for your school, you will be able to access the feature via the Data Share tab.

From here, you will be able to check the Status, Usage History and Credit Purchase History

You will also be able to purchase more credits, if needed.

Data Share Views

View Name	Source	Details
Detention_Detention	iSAMS, Ed:gen, External	Detentions for current academic year
Examination_Result	iSAMS, Ed:gen
Exclusion_Exclusion	iSAMS, Ed:gen, External	Exclusions for current academic year
FeeBilling_InvoicedCharge	iSAMS, Ed:gen
HR_ComplianceAsset	Every HR
HR_ComplianceRecordActivity	Every HR
HR_Employee	Every HR
HR_EmployeeAbsence	Every HR
HR_EmployeeJobRole	Every HR
HR_EmployeePerformanceObjective	Every HR
HR_EmployeePerformanceObservation	Every HR
HR_EmployeePerformanceReview	Every HR
HR_EmployeePerformanceStandard	Every HR
HR_EmployeeWorkPattern	Every HR
HR_Property	Every HR
Medical_StudentAppointment	iSAMS, Ed:gen
Medical_StudentCondition	iSAMS, Ed:gen
Medical_StudentMedicalHistory	iSAMS, Ed:gen
Medical_StudentMedication	iSAMS, Ed:gen
Registration_Attendance	iSAMS, Ed:gen, External	AM and PM attendance for current academic year
Registration_AttendanceHistory	iSAMS, Ed:gen	Attendance summary by term and academic year for last 3 years
RewardAndConduct_Entry	iSAMS, Ed:gen, External	Positive and negative entries for current academic year
School_Division	iSAMS, Ed:gen
School_NonTeachingDepartment	iSAMS, Ed:gen
School_Period	iSAMS, Ed:gen	Periods represent Term or Academic Year
School_School	iSAMS, Ed:gen, External
Staff_Absence	iSAMS, Ed:gen, External	Staff absence for current academic year
Staff_NonTeachingDepartmentLink	iSAMS, Ed:gen
Staff_Picture	iSAMS, Ed:gen, External
Staff_Role	iSAMS, Ed:gen, External
Staff_Staff	iSAMS, Ed:gen, External
Staff_TeachingDepartmentLink	iSAMS, Ed:gen
Student_CustomItem	iSAMS, Ed:gen
Student_History	iSAMS, Ed:gen	Information about students that are on roll in selected School Period
Student_MonthlyOccupancy	iSAMS, Ed:gen	Predicted occupancy for this and next academic year by month
Student_Picture	iSAMS, Ed:gen, External
Student_Student	iSAMS, Ed:gen, External
Teaching_TeachingDepartment	iSAMS, Ed:gen
Tracking_StageAssessment	iSAMS, Ed:gen
Wellbeing_Concern	iSAMS, Ed:gen	Concerns for current academic year

Purchasing Data Share

Please get in touch with your Customer Account Manager in the first instance.