v0.1.0 dbt_qualtrics_source
This is the initial release of the Qualtrics dbt source package!
📣 What does this dbt package do?
- Materializes Qualtrics staging tables which leverage data in the format described by this ERD. These staging tables clean, test, and prepare your Qualtrics data from Fivetran's connector for analysis by doing the following:
- Name columns for consistency across all packages and for easier analysis
- Primary keys are renamed from
idto<table name>_id. - Foreign key names explicitly map onto their related tables (ie
owner_id->owner_user_id). - Datetime fields are renamed to
<event happened>_at.
- Primary keys are renamed from
- Adds column-level testing where applicable. For example, all primary keys are tested for uniqueness and non-null values.
- Name columns for consistency across all packages and for easier analysis
- Generates a comprehensive data dictionary of your Qualtrics data through the dbt docs site.
- These tables are designed to work simultaneously with our Qualtrics transformation package.