dbt 0.20.0 Compatibility

🎉 dbt 0.20.0 Compatibility 🎉

🚨 This is a breaking change! 🚨 dbt v0.20.0 or greater is required for this release. If you are not ready to upgrade, consider using a previous release of this package.

Additional considerations when upgrading to this package:

• This package utilizes the latest v0.7.x release of the dbt-labls/dbt_utils package. If your project also utilizes a version of the fishtown-analytics/dbt_utils package then you will receive a duplicate package error. If this is the case you will need to consider upgrading your other packages to be compatible with this update or use a previous release of this package.
• Similar to the above point, all previous Fivetran dbt packages utilize the fishtown-analytics/dbt_utils package and you will need to upgrade all Fivetran dbt packages to the latest dbt 0.20.0 compatibility releases in order for your packages to run without package conflicts.
• For Databricks users this compatibility is currently only available for >=dbt 0.20.1rc1. If you want more information on upgrading your dbt-spark version, you can refer to the dbt-spark release for further details.

Postgres Compatibility

🎉 Postgres Compatibility 🎉

This release incorporates Postgres compatibility changes. These changes are non-breaking and only include changes for integration testing and Postgres specific updates to the package.

README Documentation Updates

Happy Friday 🎉

This release includes the following non-breaking changes:

• Updates to the README to call out when to properly add model configurations and fixing the pinterest ads link

Databricks Compatibility

This release incorporates the following non-breaking changes:

• Databricks compatibility

Snapchat Ads Support

This version introduces support for our latest Ad platform -- Snapchat Ads!

Bug Fix

Thank you @dschoel-pr for your contribution!

Bug Fix:

• The grain of the source data of the stg_facebook_ads, facebook_ads__ad_adapter, produces records at the ad_id level, but the stg_facebook needs it at the ad_set_id level. To avoid duplicates, the result set in the stg_facebook_ads table is now aggregated to the ad_set_id

Initial Release

This is the initial release of this package.

This dbt package aggregates and models data from multiple Fivetran advertising connectors. The package standardizes the schemas from the various ad connectors and creates a single reporting model for all activity. Activity is reported on a daily level, allowing you to analyze your ad spend, click and impressions by campaigns, ad groups and UTM parameters.

Currently the package supports Redshift, BigQuery and Snowflake.