Release Notes

August 2026

1 total change • 1 possible breaking change

Data Model(s)	Change type	Old	New	Notes
All models	`source_relation` column (when using a single Pinterest schema)	Empty string (`''`)	`<database>.<schema>`

Introduces the new (recommended) pinterest_ads_schema and pinterest_ads_database variables for defining the source schema and database respectively. The previous pinterest_schema and pinterest_database variables are still supported for backwards compatibility. This feature was applied to ensure consistent variable naming standards across Fivetran dbt packages.
Introduces the new (recommended) pinterest_ads_sources variable for more robust union data configuration. The old pinterest_ads_union_schemas and pinterest_ads_union_databases variables will still be supported. See the README for specific details.

Adds the fivetran_using_source_casing variable for case-sensitive destination support. When enabled, downstream transformations respect source casing to ensure consistent results. See the Additional Configurations section of the README for details.
Introduces fivetran_utils.partition_by_source_relation to conditionally include source_relation in partition clauses only when multiple sources are configured.

Introduces the partition_by_source_relation macro to conditionally include source_relation in window function PARTITION BY clauses only when multiple sources are configured via the pinterest_ads_union_schemas and pinterest_ads_union_databases variables.
Replaces hardcoded source_relation partitioning in the following models with the partition_by_source_relation macro:
- stg_pinterest_ads__ad_group_history
- stg_pinterest_ads__advertiser_history
- stg_pinterest_ads__campaign_history
- stg_pinterest_ads__keyword_history
- stg_pinterest_ads__pin_promotion_history

In the quickstart.yml file:
- Adds supported_vars for Quickstart UI customization.

Added configuration option to conditionally enable the keyword_report and keyword_history sources based on the ad_reporting__pinterest_ads_enabled and pinterest__using_keywords variables. This allows for better control when the keyword report and keyword history sources are disabled in your project.