- 04 Sep 2023
- 1 Minute to read
- Updated on 04 Sep 2023
- 1 Minute to read
Preset's dbt integration feature is only available for the Enterprise plan.
Preset integrates with transformation layers like dbt and Cube, allowing your team to define and manage business logic and metrics in source control to use them across multiple applications.
You can use Preset with open-source dbt Core or its hosted solution, dbt Cloud.
This article will cover how you can synchronize your dbt Cloud projects through Preset's user interface.
Connecting your dbt Cloud projects
Go to the "Database" list view by clicking on the Settings tab in the top right navigation, then select Database Connections.
Click on the Edit (pencil) icon of the database synchronized with your dbt project.
Go to the Advanced tab of the "Edit Database" modal.
Enter your dbt Cloud service auth key that has Account Admin permission (required to fetch the projects and jobs available) and the Metadata Only permission (required to fetch the model and metric definitions). Then select your "Account", "Project", "Jobs", and "Models".
You can either select an option from the dropdown list in the modal or use dbt Graph Operators if you have multiple models to sync.
- After setting up the connection, syncing will start. The selected dbt models will be synced as Preset Datasets.
Your dbt models and metrics will be synced as Preset datasets. Synchronization will happen automatically when you first set up your connection and on a daily basis.
Metrics built from multiple models will not be synchronized.
Deleting your dbt Cloud projects
If you want to delete any of the datasets synced with your dbt projects, you need to update your dbt Cloud connection first. If you delete the datasets without editing the dbt Cloud settings, the dataset will be recreated when dbt syncs again.
You can edit your dbt Cloud settings in the "Edit Database" modal.