dbt Project Repository

Before connecting Polytomic On Premises to your GitHub dbt project repository, you will first need to create a GitHub App in your GitHub organization then set some environment variables. The specific steps are as follows:

1. Go to your GitHub organization settings and click GitHub Apps:

2. Click New GitHub App:

3. As illustrated in the below two screenshots, set the following settings in your GitHub App:

• Redirect URL: YOUR_POLYTOMIC_URL/connect/dbtprojectrepository. For example, if you access Polytomic at https://polytomic.acmecorp.internal.com, then this value should be https://polytomic.acmecorp.internal.com/connect/dbtprojectrepository.
• Ensure the Webhook Active checkbox is turned off.
• Permissions:
  • Repository permissions: set Contents to Read and write.
  • Organization permissions: set Members to Read only.
  • Account permissions: set Email addresses to Read only.

4. Click Create GitHub App.
5. Note these credentials per screenshot below:

• Client ID
• Generate a new client secret
• Generate a private key

6. Set these environment variables in your Polytomic deployment (or ask your Polytomic deployment engineer to do so):

• dbtexposures_github_client_id: enter the Client ID from Step 5.
• dbtexposures_github_client_secret: enter the client secret from Step 5.
• dbtexposures_github_app_certificate: base64-encode the private key from Step 5 and set the result as the value for this variable.

7. Go to Install App then click on the Install button to install this app in your GitHub organization:

8. Log in to Polytomic and follow the instructions on the dbt Project Repository page.