PR #132 includes the following updates:
🚨 Schema Changes 🚨
- Following the July 2024 Fivetran Platform connector update, the
connector_namefield has been added to theincremental_marsource table. As a result, the following changes have been applied:- A new tmp model
stg_fivetran_platform__incremental_mar_tmphas been created. This is necessary to ensure column consistency in downstreamincremental_marmodels. - The
get_incremental_mar_columns()macro has been added to ensure all required columns are present in thestg_fivetran_platform__incremental_marmodel. - The
stg_fivetran_platform__incremental_marhas been updated to reference both the aforementioned tmp model and macro to fill empty fields if any required field is not present in the source. - The
connector_namefield in thestg_fivetran_platform__incremental_marmodel is now defined by:coalesce(connector_name, connector_id). This ensures the data model will use the appropriate field to define theconnector_name.
- A new tmp model
Under the Hood
- Updated integration test seed data within
integration_tests/seeds/incremental_mar.csvto ensure new code updates are working as expected.
Full Changelog: v1.8.0...v1.9.0