edu_wh v0.4.0

Migration guide

• In your stadium repo, add contacts and student_contact_associations to dbt/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 to dbt_utils.generate_surrogate_key() to be compatible with new version of dbt_utils that is now installed by edu_edfi_source
• Search your stadium repo for any references to stg_ef3__staff__races and replace with stg_ef3__staffs__races to be compatible with change in edu_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
   version: [ ">=0.2.0", "<0.3.0" ]

 - package: edanalytics/edu_ext_podium
   version: [ ">=0.5.0", "<0.6.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 to staffs__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