Quickstart Data Models Beta

Use Quickstart data models to run Fivetran's pre-built data models.

Overview

Fivetran offers dbt Core*-compatible data models for our most popular connectors, which transform your destination data into analytics-ready datasets. Quickstart data models allows you to use these pre-built data models without building out your own dbt project.

Once you set up a Quickstart data model, Fivetran creates the dbt project and the transformations for you. We then run the transformations according to the schedule you choose. You can view, edit, and delete each transformation from your Transformations dashboard.

IMPORTANT: Only output models are available for Quickstart transformations because they have the most analytical value.

Available connectors

See the following list of connectors that support Quickstart data models. The list also has links to the data model documentation pages for each connector for quick navigation:

NOTE: If you'd like more connectors to support Quickstart data models, submit your request.

Prerequisites

You must have an active connector of the relevant type. For example, to use the HubSpot Quickstart data model, you must have an active HubSpot connector.

Limitations

• You can only associate a Quickstart data model with one connector. If you’d like to run a Quickstart data model for multiple connectors, you must create a Quickstart data model for each one.
• You must use the same destination credentials for your Quickstart data model as you use for your connector. For example, if your connector loads data into the Test destination, you must use the Test destination to transform the data.
• Databricks on Azure destinations with OAuth authentication don't support Quickstart data models.

Supported destinations

The following destinations support Fivetran's Quickstart data models:

• BigQuery
• Databricks with Databricks Runtime
• PostgreSQL
• Redshift
• Snowflake

NOTE: If you'd like more destinations to support Quickstart data models, contact Support to submit your request.

Schema naming

Quickstart 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.

Manage data models

Add Quickstart transformation

NOTE: You can Add Quickstart Data Model when you have created a connection and it has passed the tests if the connector supports it.

1. Do either of the follwing:

   • In your Fivetran dashboard, click Transformations in the left navigation column and select your destination.
   • On the Transformations tab of the connector details page, click Add quickstart data model. In that case, the Quickstart transformation uses the default schema and all output data models, and you skip the following steps in this section.

2. Your Transformations page varies slightly based on whether or not you have set up any transformations and created connection in this destination:

   • If you don't have any transformations and connections:
     1. Click the Get Started button.
     2. Under Quickstart data models, click Install data models.
   • If you have not yet set up any transformations but have set up connections using connectors that support Quickstart data models, select the connections you want to set up the Quickstart transformations for, and click Add & run packages beside Quickstart.
   • If you have set up transformations:
     1. Click Add Transformation.
     2. Add data models beside Quickstart.

3. In the Quickstart data models page’s Source type section, do the following:

   • Choose your connector.

     TIP: If you have not yet created a connection, you can click Add connection. You will be redirected to the connector setup form. You will set up the connection, and, when the connection tests have passed, you will be able to Add Quickstart Data Model. This will add a Quickstart data model. Yet to run the model, you need to return to Step 1 of this section.

   • Choose the specific connection whose data you want to transform.

   NOTE: The Output models section automatically populates based on the source type. To learn more about these models, click Read model descriptions.

4. (Optional) If you want to place the transformed data to a custom schema, check the Use a custom schema box and enter the name of the Custom schema.

5. Click Save.

View and edit Quickstart transformation

For instructions and details on how you can view and edit Quickstart transformations, refer to our View Transformations documentation page.

Upgrade a Quickstart data model

1. Do to either of the following:

• In the transformation list, click the three dots on the right side of the relevant Quickstart transformation
• On the Transformations tab of the connector details page, click the three dots on the right side of the relevant Quickstart transformation

1. Click Upgrade package.

2. A pop-up window appears with a brief description of the upgrades and a list of the output models that are affected. Read it, then click Update package.

Delete a Quickstart data model

IMPORTANT: When you delete all output models in a Quickstart package, that package is completely removed from your dashboard, and you can no longer view its run history. If you want to schedule this transformation later, you must add a new Quickstart transformation. The new transformation will not include run history from the original model.

1. Do to either of the following:

• In the transformation list, click the three dots on the right side of the relevant Quickstart transformation
• On the Transformations tab of the connector details page, click the three dots on the right side of the relevant Quickstart transformation

1. Click Remove transformation.

2. A pop-up window appears with a warning about deleting your data model. Read it, then click Remove.

* 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.