Fivetran Data Models
Fivetran offers dbt Core-compatible data models for our top connectors (formerly known as "Fivetran dbt packages"). Our pre-built models produce clear, comprehensible tables that power your reports, visualizations, and dashboards.
Supported destinations
The following destinations support Fivetran data models:
IMPORTANT: See the relevant connector's data model documentation to find the exact list of destinations supported by the model. You do not need to enable Transformations for dbt Core* to use our models, but we recommend it.
NOTE: If you'd like more destinations to support Fivetran data models, contact Support to submit your request.
Available data models
Fivetran has data models for the following connectors:
NOTE: Our older data models have all necessary files combined into a single folder. Our newer data models are split into two models - source and transform.
NOTE: Quickstart data models enable you to run Fivetran's pre-built data models without creating a dbt project.
If you'd like Fivetran to create a data model for a connector that's not listed here, send your request to solutions@fivetran.com.
Ad reporting model
In addition to our connector-level data models, Fivetran offers a pre-built ad reporting data model that aggregates data from our most popular advertising connectors.
App reporting model
In addition to our connector-level data models, Fivetran offers a pre-built app reporting data model that aggregates data from our most popular app platform connectors.
Social media reporting model
In addition to our connector-level data models, Fivetran offers a pre-built social media reporting data model that aggregates data from our most popular social media connectors.
Shopify Holistic model
In addition to the base-level Shopify data models, Fivetran offers the Shopify Holistic data model to combine Shopify data with data from other marketing connectors. The Shopify Holistic model supports combining Shopify data with email and SMS marketing data from Fivetran's Klaviyo data model.
How it works
After Fivetran syncs your data to your destination, our data models transform your data and create analytics-ready tables in your destination.
Some data models have all necessary files combined into a single model. However, most Fivetran data models consist of two smaller models:
- The source models expose, document and standardize the underlying Fivetran schemas being created in the destination.
- The transform models produce analytics-ready data models for each source.
Source models
Source models add column-level tests and perform minor transformations on your destination data (for example, renaming columns). They are designed to help you test and clean your data and to create a dictionary of your data. They also prepare your data for our transform models, if you choose to use them.
Each source model does the following:
- Adds descriptions to the tables and columns that Fivetran has synced.
- Adds column-level testing where applicable. For example, we test all primary keys for uniqueness and non-null values.
- Models the staging tables that our transform models require.
Transform models
Transform models transform your data into analytics-ready models. They are designed to help you understand and analyze your data. They're especially helpful if you're using your connector for the first time or haven't spent much time modeling your data.
Each transform model does the following:
- Automatically installs and runs the corresponding source model.
- Performs a series of SQL transformations on the source model's staging tables. The specific transformations vary by connector.
- Produces models that address common analytics scenarios for your connector.
Schema naming
Data model schema names vary depending on the connector type. See the Change the Build Schema or Changing the Build Schema section of the relevant Transformation data model's documentation.
How to use Fivetran data models
To add Fivetran data models to your dbt project, follow the instructions in our Transformations for dbt Core setup guide.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.