Illuminate DnA¶
| Vendor: | Illuminate Education |
|---|---|
| Frequency: | Nightly |
| Method: | A SQL query is run against the Illuminate database with the result replicated to BigQuery under the Staging dataset. |
Initial setup¶
Airflow connections¶
Our DAG looks for the following Airflow connection:
illuminate_odbc
- Conn type: Postgres
- Host: Illuminate database IP address
- Schema: Illuminate database name
- Login: Illuminate odbc username
- Password: Illuminate odbc password
- Port: 5432
Data we pull¶
| Table Name | Column Name | BigQuery Column Name |
|---|---|---|
| public.students | local_student_id | StudentUniqueId |
| public.students | last_name | LastSurname |
| public.students | first_name | FirstName |
| dna_assessments.assessments | assessment_id | AssessmentIdentifier |
| dna_assessments.assessments | title | AssessmentTitle |
| codes.dna_subject_areas | code_translation | AcademicSubject |
| codes.dna_scopes | code_translation | Scope |
| public.grade_levels | short_name | GradeLevels |
| dna_assessments.students_assessments | date_taken | AdministrationDate |
| dna_assessments.agg_student_responses | points | Points |
| dna_assessments.agg_student_responses | points_possible | PointsPossible |
| dna_assessments.agg_student_responses | percent_correct | Result |
| dna_assessments.performance_bands | label | PerformanceBandLabel |