Data Share and Snowflake
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.
Purchasing Data Share
Please get in touch with your Customer Account Manager in the first instance.
Using Snowflake Credits to Access Data Share
When you access data in Snowflake via Data Share, you will use Snowflake credits to pay for the compute services that allow you to query the shared data.
The amount of credits you use depends on how much computing power and resources you need. You can buy more credits and set limits on their usage to stay within your budget.
Further information on compute costs and Snowflake credits can be found in 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 of your Data Share.
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 |