v0.7.0 dbt_snapchat_ads_source

PR #24 includes the following BREAKING CHANGE updates:

Feature Updates: Conversion Support

We have added more robust support for conversions in our data models by doing the following:

• Created a snapchat_ads__conversion_fields variable to pass through additional conversion fields in the stg_snapchat_ads__ad_hourly_report,stg_snapchat_ads__ad_squad_hourly_report and stg_snapchat_ads__campaign_hourly_report models.
  • By default, snapchat_ads__conversion_fields will bring in the most used conversion field, conversion_purchases. See the README for details on how to adjust this.
• Brought in the conversion_purchases_value field to the above mentioned stg_snapchat_ads__*_hourly_report models.

IMPORTANT: The above new field additions are breaking changes for users who were not already bringing in conversion fields via passthrough columns.

Documentation Update

• Documented how to use the new snapchat_ads__conversion_fields variable here.
• Added new metrics to src and stg yml files.

Under the Hood

• Updated snapchat_*_hourly_report_data seed files with relevant conversion fields for more robust testing.
• Ensured backwards compatibility with existing passthrough column frameworks by creating snapchat_ads_add_pass_through_columns and snapchat_ads_fill_pass_through_columns macro checks for whether these conversion fields are already brought in by the existing passthrough variables. This ensures there are no duplicate column errors if both the new conversion variable and the old passthrough variable are leveraged in any stg_snapchat_ads__*_hourly_report* data model.

Contributors

• Seer Interactive

Full Changelog: v0.6.0...v0.7.0

v0.6.0 dbt_snapchat_ads_source

PR #20 includes the following updates:

Feature update 🎉

• Unioning capability! This adds the ability to union source data from multiple snapchat_ads connectors. Refer to the Union Multiple Connectors README section for more details.

Under the hood 🚘

• Updated tmp models to union source data using the fivetran_utils.union_data macro.
• To distinguish which source each field comes from, added source_relation column in each staging model and applied the fivetran_utils.source_relation macro.
• Updated tests to account for the new source_relation column.

PR #17 includes the following updates:

• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job.
• Updated the pull request templates.

Full Changelog: v0.5.0...v0.6.0

dbt_snapchat_ads_source v0.5.0

🚨 Breaking Changes 🚨:

PR #15 includes the following breaking changes:

• Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically {{ dbt_utils.<macro> }} have been updated to {{ dbt.<macro> }} for the below macros:
  • any_value
  • bool_or
  • cast_bool_to_text
  • concat
  • date_trunc
  • dateadd
  • datediff
  • escape_single_quotes
  • except
  • hash
  • intersect
  • last_day
  • length
  • listagg
  • position
  • replace
  • right
  • safe_cast
  • split_part
  • string_literal
  • type_bigint
  • type_float
  • type_int
  • type_numeric
  • type_string
  • type_timestamp
  • array_append
  • array_concat
  • array_construct
• For current_timestamp and current_timestamp_in_utc macros, the dispatch AND the macro names have been updated to the below, respectively:
  • dbt.current_timestamp_backcompat
  • dbt.current_timestamp_in_utc_backcompat
• Dependencies on fivetran/fivetran_utils have been upgraded, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

dbt_snapchat_ads_source 0.4.0

PR #13 applies the Ad Reporting V2 updates:

🚨 Breaking Changes 🚨

• Changes snapchat_schema and snapchat_database variable names to snapchat_ads_schema and snapchat_ads_database
• Updates model names to prefix with snapchat_ads

🎉 Feature Enhancements 🎉

• Adds the ad_squad_hourly_report and campaign_hourly_report source tables and accompanying staging models
• Adds the field descriptions and grain uniqueness tests for the new models
• Adds additional fields to existing models
• Applies README standardization updates
• Introduces the identifier variable for all source models
• Casts all timestamp fields using dbt_utils.type_timestamp()
• Inclusion of passthrough metrics:
  • snapchat_ads__ad_hourly_passthrough_metrics
  • snapchat_ads__ad_squad_hourly_passthrough_metrics
  • snapchat_ads__campaign_hourly_report_passthrough_metrics

This applies to all passthrough columns within the dbt_snapchat_ads_source package and not just the snapchat_ads__ad_hourly_passthrough_metrics example.

vars:
  snapchat_ads__ad_hourly_passthrough_metrics:
    - name: "my_field_to_include" # Required: Name of the field within the source.
      alias: "field_alias" # Optional: If you wish to alias the field within the staging model.

• Add enable configs for this specific ad platform, for use in the Ad Reporting rollup package

snapchat_ads_source v0.3.1

Bug Fixes

• Includes updated_at in uniqueness tests on stg_snapchat__creative_url_tag_history. This was originally missing, causing erroneous uniqueness test failures on this history table (#10).

snapchat_ads_source 0.3.0

🎉 dbt v1.0.0 Compatibility 🎉

🚨 Breaking Changes 🚨

• Adjusts the require-dbt-version to 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 latest dbt_fivetran_utils package also has a dependency on dbt_utils [">=0.8.0", "<0.9.0"].
  • Please note, if you are installing a version of dbt_utils in your packages.yml that is not in the range above then you will encounter a package dependency error.

Spend Micros Conversion

Happy Wednesday!

This release includes the following update to the Fivetran Snapchat source dbt package:

• Applied conversion to the spend field within the stg_snapchat__ad_hourly_report that translates the spend out of micros. This is required as per Snapchat documentation the spend field is originally stated in micros. PR #7

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.

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.

Fivetran Utils Dependency Update

🚧 Fivetran Utils Dependency Update 🚧

This release includes the following non-breaking changes:

• Update to the packages.yml to reference the recently released Fivetran Utils package. This is a necessary update to ensure this package is compatible with previous dbt releases before dbt v0.20.0 updates take place.