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 a Quickstart data model

1. Click Transformations.

2. Select the destination.

3. Your Transformations page varies slightly based on whether or not you have set up any transformations for this destination:

   • If you don't have any transformations:
     1. Click the Get Started button.
     2. Under Quickstart data models, click Install data models.
   • If you have set up transformations, click Add transformation > Quickstart Transformation.

4. In the Quickstart data models page’s Select output models section, enter the following information:

   • Source type: Choose your data source.
   • Connector: Choose the specific connector 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.

   

5. The Set schedule section then appears. Choose the schedule type (integrated or custom) for the Quickstart data model. If you selected a custom schedule, choose the days and frequency for your transformation runs.

   TIP: We recommend using an integrated schedule to ensure data integrity.

   

6. Click Save.

View a Quickstart data model

1. In your Transformations page, click Settings.

2. On the Quickstart Transformations Management tab, you'll see the following information for each Quickstart data model:

   • Connectors: The connector associated with the Quickstart data model.
   • Quickstart Models: The Quickstart data model name (usually the data source). You can filter this list by model type.
   • Transformations: The number of output models in the Quickstart data model, as well as their status (live or removed).
   • Schedules: The schedule type for all output models in the Quickstart data model (integrated, custom, or a mix of the two).
   • Upgrades: Fivetran periodically updates our pre-built data models. When your output models have an upgrade ready, we notify you in this column.

   

Edit a Quickstart data model schedule

1. On the Quickstart Transformations tab, click the three vertical dots to the right of the transformation name, then click Edit all schedules.

   

2. A pop-up window appears with your transformation’s current schedule. Make your desired changes, then click Update all schedules to update the schedules for all output models in the Quickstart data model.

   

Edit an output model schedule

1. On the main Transformations page, click the three vertical dots to the right of the output model name, then click View Schedule.

   

2. On the Schedule tab, edit the output model's schedule, then click Save.

   

Upgrade a Quickstart data model

1. In the Upgrades column of the Quickstart Transformations tab, click Upgrade available.

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. On the Quickstart Transformations tab, click the three vertical dots to the right of the data model name, then click Remove transformations.

   

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

Delete an output model

1. On the main Transformations page, click the three vertical dots to the right of the output model name, then click Remove transformation.

   

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

Restore a Quickstart data model

1. On the Quickstart Transformations tab, click on the three vertical dots to the right of the data model name, then click Restore transformations.

   

2. A pop-up window appears with a list of your active and inactive transformations. In the Select models to restore section, check the boxes of all transformations you want to restore.

   

3. Define a schedule (integrated or custom) for the restored models.

4. Click Restore transformations.

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