dbt Git repository
- 17 Jul 2024
- Print
- PDF
dbt Git repository
- Updated on 17 Jul 2024
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
summary
Before the dbt job can actually be executed, a Git repository must be linked to TROCCO.
This article describes how to create, edit, and delete a dbt Git repository.
Hosting services supported by this function
The dbt integration supports GitHub and GitLab as hosting services for Git repositories.
It is also available for on-premise environments using GitHub Enterprise, etc.
Various operations on dbt Git repository
New additions
- On the dbt Git repository list screen, click Add New.
- On the Create New dbt Git Repository screen, enter and select each item and click Save.
Request for permission of IP address
If you are using GitHub Enterprise or other means to deny access to your Git server from any IP address other than the specific IP address, please allow access to the IP address that TROCCO uses for communication.
IP addresses that need to be allowed by security groups, firewalls, etc.
- Register the Deploy Key to the Git server.
If you are using GitHub
Deploy Key can be registered at the following URL.
https://github.com/<GitHub username>/<repository name>/settings/keys
editing
- On the dbt Git repository list screen, click the dbt Git repository you wish to edit.
- On the dbt Git repository edit screen, edit the settings and click Save.
deletion
- In the dbt Git repository list screen, click on the dbt Git repository you wish to delete.
- On the dbt Git repository edit screen, click the icon in the red frame and click Remove.
Various settings for dbt Git repository
| item name | indispensable | Contents |
|---|---|---|
| Repository URL | Yes | Enter the URL of the target repository. Only GitSSH format input is supported. |
| branch name | Yes | Enter the target branch name. |
| subdirectory | No | You can specify a subdirectory in the Git repository as the project directory. Enter for cases where dbt_project.yml is not directly under the root directory.Note that if you specify the repository root directory as the project directory, do not enter anything. |
| dbt version | Yes | You can select the version of dbt Core to use. |
role permission
If you use the team function
The dbt Git repository is treated as a resource in TROCCO.
* See Resource Definition: Team Functions.
* Permissions to operate on resources: see Resource Groups.
| Role | Resource Group Administrator | Resource Group Editor | Resource Group Operator | Resource Group Viewer | No Role | Supplemental | Supplemental
| --- | --- | --- | --- | --- | --- | --- |
| dbt Edit Git Repository | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | - - - - - - | | |
| dbt Remove Git Repository | ✓ | ✓ | ✓ | ✓ | - | - | - | | |
| dbt Gitリポジトリの運用 | ✓ | ✓ | ✓ | - | - | dbtジョブ設定に利用できます。 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓
| dbt Add a new Git repository | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓
Was this article helpful?