PR #12 includes the following updates:
Under the Hood
- Switched from using
dbt.current_timestamp_backcompat()
to the more up-to-datedbt.current_timestamp_backcompat()
macro in thequaltrics__daily_breakdown
model. - (Maintainers only) Adds consistency and integrity (row count) tests for each end model.
Upstream Under-the-Hood Updates from qualtrics_source
Package
- Explicitly casts all boolean fields as
{{ dbt.type_boolean() }}
. - (Affects Redshift only) Creates new
qualtrics_union_data
macro to accommdate Redshift's treatment of empty tables.- For each staging model, if the source table is not found in any of your schemas, the package will create a empty table with 0 rows for non-Redshift warehouses and a table with 1 all-
null
row for Redshift destinations. - This is necessary as Redshift will ignore explicit data casts when a table is completely empty and materialize every column as a
varchar
. This throws errors in dowstream transformations in thezendesk
package. The 1 row will ensure that Redshift will respect the package's datatype casts.
- For each staging model, if the source table is not found in any of your schemas, the package will create a empty table with 0 rows for non-Redshift warehouses and a table with 1 all-
Full Changelog: v0.2.0...v0.3.0