Migration guide
- In your stadium repo, add
contacts
andstudent_contact_associations
todbt/models/staging/src_edfi_3.yml
- example snippets:
- name: contacts
description: >
This entity represents a contact of a student, such as a parent, guardian or caretaker.
enabled: true
columns: *column_defaults
- name: student_contact_associations
description: >
This association relates students to their parents, guardians, or caretakers.
enabled: true
columns: *column_defaults
- Snowflake admin, run this DDL to create the new raw tables:
use role sysadmin;
-- FIRST, confirm ods_verson and data_model_version are included in your _template tables (should have been updated on previous upgrade migration)
-- alter table dev_raw.edfi3._template_table
-- add ods_version varchar, data_model_version varchar;
-- alter table raw.edfi3._template_table
-- add ods_version varchar, data_model_version varchar;
create or replace table dev_raw.edfi3.contacts
like dev_raw.edfi3._template_table;
create or replace table dev_raw.edfi3.student_contact_associations
like dev_raw.edfi3._template_table;
create or replace table raw.edfi3.contacts
like raw.edfi3._template_table;
create or replace table raw.edfi3.student_contact_associations
like raw.edfi3._template_table;
- Search your stadium repo for any uses of
dbt_utils.surrogate_key()
- these must be updated todbt_utils.generate_surrogate_key()
to be compatible with new version of dbt_utils that is now installed byedu_edfi_source
- Search your stadium repo for any references to
stg_ef3__staff__races
and replace withstg_ef3__staffs__races
to be compatible with change inedu_edfi_source
- Bump the versions of the following in
packages.yml
(the ext packages in these versions are needed for the dbt utils upgrade):
- package: edanalytics/edu_wh
version: [ ">=0.4.0", "<0.5.0" ]
- package: edanalytics/edu_ext_one_roster
revision: 0.2.0
- package: edanalytics/edu_ext_podium
revision: 0.5.0
What's Changed
- add missing fk declarations by @ejoranlienea in #123
- fix model name in grad plan docs by @ejoranlienea in #140
- Feature/Include Contacts and Parents data in parent tables due to Ed-Fi rename by @sleblanc23 in #142
- fix stu-school-att unique test by @rlittle08 in #144
- Feature/new DS5 optional fields on staff by @sleblanc23 in #147
- New DS5 optional fields for dim_course_section by @johncmerfeld in #150
- Feature/dim course section custom fields by @rlittle08 in #149
- add cohort year in dim_student by @keenzarate213 in #141
- fix missing commas in constraints by @rlittle08 in #153
- Update
staff__races
tostaffs__races
by @tomreitz in #151 - Update to dbt_utils 1.0+ (1.3.0) by @gnguyen87 in #143
- Add PR template by @rlittle08 in #127
- Bump/0.4.0 by @rlittle08 in #154
New Contributors
- @gnguyen87 made their first contribution in #143
Full Changelog: 0.3.4...0.4.0