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

Introduces the new (recommended) qualtrics_sources variable for more robust union data configuration. The oldqualtrics_union_schemas and qualtrics_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 multiplesources are configured.
Removed qualtrics.qualtrics_union_data and replaced the references with the standardized fivetran_utils.union_data macro.

Disables qualtrics__contact if both the directory_contact and core_contact source tables are disabled.
Allows qualtrics__response, qualtrics__directory, and qualtrics__daily_breakdown to run without directory_contact or contact_mailing_list_membership source tables.
- dbt Core only: Leverages the qualtrics__using_directory_contacts and qualtrics__using_contact_mailing_list_memberships variables to enable/disable data from these sources.

Fixes a Redshift error in qualtrics__contact, qualtrics__survey, and qualtrics__distribution where percentile_cont raised a "Non supported data-type in order-by expression" error. Redshift requires float values in ORDER BY expressions within percentile_cont. The following fields are now cast to float on Redshift before being passed to the percentile calculation:
- qualtrics__contact and qualtrics__survey: duration_in_seconds, progress
- qualtrics__distribution: time_to_open_in_seconds, time_to_start_in_seconds, time_to_complete_in_seconds

Introduces the qualtrics_percentile macro to manage Redshift-specific percentile behavior. The macro dispatches to a Redshift implementation that applies the float cast, and delegates to fivetran_utils.percentile for all other warehouses.

Increases required DBT version upper limit to v3.0.0 in the project.yml, correcting an earlier error.

In the quickstart.yml file:
- Adds table_variables for relevant sources to prevent missing sources from blocking downstream Quickstart models.
- Adds supported_vars for Quickstart UI customization.

Fixed integration test configuration by adding missing identifier variables to properly scope qualtrics source table references in the integration tests dbt_project.yml.