dbt

Follow these steps to connect your dbt project to Select Star.

Before you start

To connect dbt to Select Star, you will need...

• Permission to build the dbt project

Select Star won't need any permissions for dbt directly, but you will need to build the dbt project and generate build artifacts.

Complete the following steps to connect dbt to Select Star.

1. Determine what kind of dbt connection you need

2. Connect dbt to Select Star

Note that in order to see changes to your dbt project reflected in Select Star after the initial connection, you must complete either step 3 or step 4.

1. Determine what kind of dbt connection you need

Select Star can integrate with dbt via dbt cloud or via build artifacts (manifest.json, catalog.json, etc).

for DBT Cloud we require...

• a service token for the metadata api

• a job id for a custom job that will generate all the metadata we need

  • see DBT Cloud - Setup a dbt Cloud Custom Job for details about how to set up the job

• a Read Only and Metadata Only permission set

2. Connect dbt to Select Star

If you are using multiple dbt projects and have cross-project dependencies see dbt Project Dependencies.

Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

Choose dbt in the Source Type dropdown and then follow the instructions for how you want to connect:

dbt Clouddbt Core (open source)

Features

dbt Tagsdbt Tests