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 Microsoft Ads schema)	Empty string (`''`)	`<database>.<schema>`

Introduces the new (recommended) microsoft_ads_sources variable for more robust union data configuration. The old microsoft_ads_union_schemas and microsoft_ads_union_databases variables will still be supported. See the README for specific details.

Renamed the source identifier variable for geographic_performance_daily_report.
- new: microsoft_ads_geographic_performance_daily_report_identifier
- previous: microsoft_ads_geographic_history_identifier

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.

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

Removed the dependency on the fivetran/microsoft_ads_source package.
- All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
- If you reference fivetran/microsoft_ads_source in your packages.yml, you must remove this dependency to avoid conflicts.
- Any source overrides referencing the fivetran/microsoft_ads_source package will also need to be removed or updated to reference this package.
- Update any microsoft_ads_source-scoped variables to be scoped to only under this package. See the README for how to configure the build schema of staging models.
As part of the consolidation, vars are no longer used to reference staging models, and only sources are represented by vars. Staging models are now referenced directly with ref() in downstream models.

Updated package to maintain compatibility with dbt-core versions both before and after v1.10.6, which introduced a breaking change to multi-argument test syntax (e.g., unique_combination_of_columns).
Temporarily removed unsupported tests to avoid errors and ensure smoother upgrades across different dbt-core versions. These tests will be reintroduced once a safe migration path is available.
- Removed all dbt_utils.unique_combination_of_columns tests.
- Moved loaded_at_field: _fivetran_synced under the config: block in src_microsoft_ads.yml.