Adding a dbt project

Adding a dbt project#

Note

This feature is in beta stage. To join the beta program, please reach out to ux-research@adverity.com.

To run, schedule and monitor your dbt project executions in Adverity, you need to add the dbt project and configure the connection settings.

Prerequisites#

Note

This feature is available only to users with Administrator permissions in the root workspace of your organization.

Before you complete the procedure in this guide, perform all the following actions:

  • Create a Git repository for your dbt project. For more information, see the dbt documentation.

  • Ensure you have permissions to add deploy keys to your repository.

  • Set up a data warehouse destination in Adverity with a valid authorization. For more information, see Loading data into destinations.

Adding your dbt project to Adverity#

To add your dbt project to Adverity, follow these steps:

  1. Go to the dbt Projects page.

  2. Click + Create project.

  3. In Name, enter a name for your project in Adverity. It does not have to match your repository name.

  4. In Warehouse, select a data warehouse from your existing Adverity destinations where your dbt transformations will be applied. Adverity will automatically create a profile.yaml file to connect to the warehouse during the dbt run.

  5. In Git repository SSH URL, enter the SSH URL of the repository with your dbt project.

  6. Copy the Adverity public key and add it to your Git repository as a deploy key.

  7. Click Create.

Editing the dbt project connection to Adverity#

To update the details of how your dbt project is connected to Adverity, follow these steps:

  1. Go to the dbt Projects page.

  2. Click on the name of the dbt project that you want to update.

  3. In the Credentials section, modify the following fields if necessary:

    Git repository SSH URL

    Click image1 Edit and enter the new SSH URL.

    Public key

    Click image2 Copy to copy the key to the clipboard and then add it to your Git repository as a deploy key.

    Warehouse

    Click image1 Edit and select the data warehouse that you want to use.

Removing a dbt project from Adverity#

To remove a dbt project from Adverity, follow these steps:

  1. Go to the dbt Projects page.

  2. In the Projects table, find the project that you want to remove.

  3. Click image3 Select an action in a specific project’s row.

  4. Click image4 Delete.

As a result, this project is removed from Adverity. This action does not affect the Git repository of the project.

Contents