GitHub
An overview of the GitHub integration with Secoda
Getting Started with GitHub
GitHub is a supplementary integration that track impact of potential changes and notifies the relevant people. Before connecting GitHub, ensure you have a dbt integration already set up in Secoda.
There are 2 steps to connect GitHub with Secoda:
Retrieve your dbt integration id associated with the GitHub repository
Connect Github to Secoda
Retrieve your dbt Integration ID
The GitHub integration uses the metadata extracted from your dbt integration. To retrieve your dbt integration id, follow these steps:
Navigate to your Secoda workspace.
Click on the 'Integrations' tab in the bottom left corner.
Find your dbt integration that matches to the GitHub repository you are trying to integrate.
Extract the ID from the URL. For example, in 'app.secoda.co/integrations/aa29401b-32c5-4f1f-9003-8473e90589e5/basic', the integration ID would be 'aa29401b-32c5-4f1f-9003-8473e90589e5'.
Connect Github to Secoda
After retrieving the dbt integration id, the next step is to connect to Secoda:
In the Secoda App, select ‘Add Integration’ on the Integrations tab.
Search for and select GitHub.
Enter the retrieved dbt integration ID.
Click 'Connect with OAuth' and follow the login steps, if needed.
Select the location you want to install, either personal or organization.
Select 'Only select repositories', and use the dropdown to select the specific repository associated with the dbt integration.
Click install.
After Connecting to Secoda
Once the connection is setup, Secoda will check any new pull requests opened in that repository for entities that exist within your workspace. If any deletions are present on the entities, a comment will be written on the pull request of the affected entities, and all immediate downstream entities. An email with the same information will be sent out to all owners of affected entities as well.
Sync metadata back to dbt
Run a metadata sync to update your dbt resources with the info your have changed in Secoda. When a sync is run, Secoda will update dbt metadata files that relate to Secoda resources in your workspace and create a new pull request in your repositories for you to review before merging. The following metadata will be updated from Secoda:
descriptions
tags
owners
column descriptions
Last updated