Skip to content

Latest commit

 

History

History
115 lines (101 loc) · 7.43 KB

CHANGELOG.md

File metadata and controls

115 lines (101 loc) · 7.43 KB

dbt_snapchat_ads_source v0.7.0

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

dbt_snapchat_ads_source v0.6.0

PR #20 includes the following updates:

Feature update 🎉

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.

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 v0.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

dbt_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).

dbt_snapchat_ads_source v0.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.

dbt_snapchat_ads_source v0.1.0 -> v0.2.1

Refer to the relevant release notes on the Github repository for specific details for the previous releases. Thank you!