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 StatusUsage 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