dbt Project Repository

📘

Polytomic On Premises

if you are running Polytomic On Premises, make sure to follow the instructions here first: dbt Project Repository On Premises. Once done you'll be able to execute the steps on this page.

Polytomic connects to a GitHub dbt project repository using the Polytomic GitHub application. Follow these steps to make the connection:

1. Go to the Polytomic GitHub App page and install the app into your organization with access to your dbt repository. Depending on your organization's permissions, an administrator may need to approve the app before installation is complete.

2. In Polytomic, go to Connections → Add Connection → dbt Project Repository.

3. Click on Connect to dbt Project Repository to authenticate to your GitHub account:

4. Once connected, select your dbt GitHub repository:

5. Click Save. Alternatively, if you want to enable dbt exposure commits, see below.

Enabling dbt exposure commits

dbt exposures format

Polytomic has the ability to commit dbt exposures to your GitHub dbt repository. All commits are made to one file: models/polytomic_sync_exposures.yml.

This file will contain a list of Polytomic Model Syncs and the dbt models that each sync is pulling from.

Instructions

To enable dbt exposure commits:

1. Tick the Commit exposures file box.
2. Select the GitHub repository branch to which Polytomic should commit changes to its exposures file:

3. Click Save.

After this, Polytomic will automatically commit an update to this file on your chosen branch every time you save a Model Sync.

If you ever need to, you can delete models/polytomic_sync_exposures.yml from your dbt repository and Polytomic will automatically regenerate it.