Skip to content
This repository was archived by the owner on Jan 20, 2026. It is now read-only.

v0.9.0 dbt_facebook_ads_source

Choose a tag to compare

@fivetran-data-model-bot fivetran-data-model-bot released this 29 Apr 22:16
· 2 commits to main since this release
69ecea0

PR #44 introduces the following updates:

Schema Updates

9 total changes • 0 possible breaking changes

Data Model Change type Old name New name Notes
stg_facebook_ads__demographics_country New Model Uses demographics_country source table
stg_facebook_ads__demographics_country_tmp New Model Uses demographics_country source table
stg_facebook_ads__demographics_country_actions New Model Uses demographics_country_actions source table
stg_facebook_ads__demographics_country_actions_tmp New Model Uses demographics_country_actions source table
stg_facebook_ads__demographics_region New Model Uses demographics_region source table
stg_facebook_ads__demographics_region_tmp New Model Uses demographics_region source table
stg_facebook_ads__demographics_region_actions New Model Uses demographics_region_actions source table
stg_facebook_ads__demographics_region_actions_tmp New Model Uses demographics_region_actions source table
stg_facebook_ads__account_history New Columns business_state, timezone_offset_hours_utc, min_daily_budget

Feature Updates:

  • Added the facebook_ads__using_demographics_country and facebook_ads__using_demographics_region variables, which can be used to enable or disable the above transformations related to the demographics_country/demograhics_country_actions and demographics_region/demographics_region_actions tables.
    • These variables are dynamically set for Fivetran Quickstart users, but false by default otherwise. See README for more details on how to enable these models, particularly if you are using dbt Core.
  • Introduced the following passthrough column variables, which can be used to pass through additional metrics fields from their respective source reports to downstream models. See README for more details.
    • facebook_ads__demographics_country_passthrough_metrics
    • facebook_ads__demographics_country_actions_passthrough_metrics
    • facebook_ads__demographics_region_passthrough_metrics
    • facebook_ads__demographics_region_actions_passthrough_metrics

Full Changelog: v0.8.1...v0.9.0