Skip to content

dbt_snapchat_ads_source 0.4.0

Compare
Choose a tag to compare
@fivetran-sheringuyen fivetran-sheringuyen released this 01 Sep 06:41
· 37 commits to main since this release
99be4af

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