Quickstart Management
Learn how to add, view, edit, upgrade, and delete Quickstart data models in the Fivetran dashboard.
Add Quickstart transformation
You can add a Quickstart data model after you have created a connection that supports the model and that connection has passed its setup tests."
Do either of the following:
- In your Fivetran dashboard, click Transformations in the left navigation column.
- On the Transformations tab of the connection 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.
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:
- Click the Get Started button.
- 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:
- Click Add Transformation.
- Add data models beside Quickstart.
- If you don't have any transformations and connections:
Select the Quickstart package type:
- Single source package - Selecting this option models each connection individually.
- Multi source - Selecting this option uses multi-source packages to model and merge data from connections of similar types supported by the package.
Select the connections you want to model by checking their boxes.
If you have not yet created a connection, you can click Add connection. You will be redirected to the connection setup form. Set up the connection, and, when the connection tests have passed, you can Add Quickstart Data Model. This will add a Quickstart data model. To run the model, you need to return to Step 1 of this section.
The Model count displays the total number of output and intermediate models used in a transformation and it automatically populates based on the source type.
To learn more about the added output models, click View info beside the relevant mode.
(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.
Select the schedule. You have the following scheduling options:
- Integrated: Fivetran runs your transformation after each upstream connector has accomplished its sync. You can see the list of Upstream Connectors and Sync Frequency.
- Custom: Fivetran runs your transformation at the frequency of your choice. If you've enabled the Smart syncing option, the model won't run until connectors have completed syncing when schedules overlap. Custom scheduling allows you to select particular days of the week to run your transformation, a run frequency within a day, and when the run frequency is set to 24 hours, a particular run time for your transformation. Available run intervals are as follows:
- 1 min
- 5 min
- 15 min
- 30 min
- 1 hour
- 2 hours
- 3 hours
- 6 hours
- 8 hours
- 12 hours
- 24 hours
When you set a 24-hour run interval, you can also select a particular time to run your transformation at. 5. Click Save. If you are bulk-creating single-source data models, they are added as individual models in your transformation list. If you are creating a multi-source data model, it is displayed as a single data model. The Connections columns in that case displays the number of associated connections with up to three connector logos followed by an integer. For example, if your data model has 15 connections associated with it, the three logos are followed by '(+12)'.
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.
Review upcoming Quickstart schema changes
- 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 connection details page, click the three dots on the right side of the relevant Quickstart transformation
- Click Review update.
A pop-up window appears with a brief description of the schema changes and a list of the output models that are affected.
Delete a Quickstart data model
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.
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
Click Remove transformation.
A pop-up window appears with a warning about deleting your data model. Read it, then click Remove.