v0.2.0 dbt_qualtrics

PR #8 includes the following updates:

🚨 Breaking Changes: Upstream Changes 🚨

• This release includes an update to the upstream dbt_qualtrics_source dependency which includes breaking changes. These breaking changes included all staging model timestamps to be cast using the dbt.type_timestamp() macro in order to ensure datatype consistency with timestamp fields.
  • For an overview of all breaking changes in the dbt_qualtrics_source data model, please refer to the respective release notes.

Full Changelog: v0.1.1...v0.2.0

v0.1.1 dbt_qualtrics

PR #6 applies the following changes:

Bug Fix

• Ensures the date spine in the qualtrics__daily_breakdown model always has a non-null start date, especially if you do not have the distribution_contact source table whose min(created_at) is used to generate the date spine.
  • If no distribution_contact table is present in your Qualtrics connector(s), the minimum date will be set to 2016-01-01.

Under the Hood

• Updated the pull request templates.
• Included auto-releaser GitHub Actions workflow to automate future releases.

Full Changelog: v0.1.0...v0.1.1

v0.1.0 dbt_qualtrics

This is the initial release of the Qualtrics dbt package!

📣 What does this dbt package do?

This package models Qualtrics data from Fivetran's connector. It uses data in the format described by this ERD and builds off the output of our Qualtrics source package.

The main focus of the package is to transform the core object tables into analytics-ready models, including:

• A Response breakdown model which consolidates all survey responses joined with users, questions, and survey details.
• Overview models for Surveys, Contacts, Directories, and Distributions which help to understand the nuances of each and how they affect key survey aggregations.
• A daily breakdown model which provides a high level view of a variety of Qualtrics account metrics at a daily level.