v0.12.0 dbt_pinterest_source

PR #39 includes the following updates:

Schema Changes

7 total changes • 0 possible breaking changes

Data Model	Change type	Old name	New name	Notes
stg_pinterest_ads__pin_promotion_targeting_report	New Staging Model			Uses pin_promotion_targeting_report source table
stg_pinterest_ads__targeting_geo_region	New Staging Model			Uses targeting_geo_region source table
stg_pinterest_ads__targeting_geo	New Staging Model			Uses targeting_geo source table
stg_pinterest_ads__pin_promotion_targeting_report_tmp	New Temp Model			Uses pin_promotion_targeting_report source table
stg_pinterest_ads__targeting_geo_region_tmp	New Temp Model			Uses targeting_geo_region source table
stg_pinterest_ads__targeting_geo_tmp	New Temp Model			Uses targeting_geo source table
stg_pinterest_ads__campaign_history	New Columns		start_time, end_time, budget_spend_cap, lifetime_spend_cap, objective_type

Features

• Added the following vars to enable/disable the new sources. Refer to the README for more details.
  • pinterest__using_pin_promotion_targeting_report
    • Default is true. Will disable stg_pinterest_ads__pin_promotion_targeting_report if false.
  • pinterest__using_targeting_geo
    • Default is true. Will disable stg_pinterest_ads__targeting_geo if false.
  • pinterest__using_targeting_geo_region
    • Default is true. Will disable stg_pinterest_ads__targeting_geo_region if false.
• Added the var pinterest__pin_promotion_targeting_report_passthrough_metrics to allow bringing additional metrics in to the stg_pinterest_ads__pin_promotion_targeting_report model. Refer to the README for more details.

Under the Hood

• Added get_*_columns macros for new sources
• Added seed data for testing new sources

Documentation

• Updated dbt documentation to reflect new tables and column additions.
• Corrected references to connectors and connections in the README. (#38)

Full Changelog: v0.11.0...v0.12.0