- The
stg_zendesk__tickettable now allows for your custom passthrough columns to be added via thezendesk__ticket_passthrough_columnsvariable. You can add your passthrough columns as a list within the variable in your project configuration. (#27)
- Incorporates the
daylight_timeandtime_zonesource tables into the package. In the transform package, these tables are used to more precisely calculate business hour metrics (#62).
🎉 dbt v1.0.0 Compatibility 🎉
- Adjusts the
require-dbt-versionto now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.- For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
- For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.
- Upgrades the package dependency to refer to the latest
dbt_fivetran_utils. The latestdbt_fivetran_utilspackage also has a dependency ondbt_utils[">=0.8.0", "<0.9.0"].- Please note, if you are installing a version of
dbt_utilsin yourpackages.ymlthat is not in the range above then you will encounter a package dependency error.
- Please note, if you are installing a version of
- Adjusted timestamp fields within staging models to explicitly cast the data type as
timestamp without time zone. This fixes a Redshift error where downstream datediff and dateadd functions would result in an error if the timestamp fields are synced astimestamp_tz. (#23)
- @juanbriones (#55)
Refer to the relevant release notes on the Github repository for specific details for the previous releases. Thank you!