About dbt linkage
  • 17 Jul 2024
  • PDF

About dbt linkage

  • PDF

Article summary


What is dbt?

dbt is a development framework that allows modular handling of SQL.
* Combined with Jinja, a template language for Python, you can write more flexible data conversion code.
* Connect to a supported data warehouse and query the tables in the data warehouse.
* Automated testing can also be performed during the query execution phase.

For more information, please refer to the official dbt page.

TROCCO's dbt linkage

TROCCO works with the Git repository that manages the dbt code.
You can then create and run a dbt job configuration that allows you to run dbt commands against the code in the repository.
The created dbt jobs can also be incorporated into TROCCO's workflow functionality.

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.

dbt supported versions

As of 06/2024, TROCCO supports the following versions

  • dbt Core v1.8
  • dbt Core v1.7
  • dbt Core v1.6
  • dbt Core v1.5
  • dbt Core v1.4
  • dbt Core v1.3

advance preparation

To actually run a dbt job, the following preparations must be made
Please refer to the link for more information on the preparation procedure.
* Add dbt Git repository
* Add dbt job settings

Supported adapters

In dbt, the data warehouses that dbt supports are denoted as adapters.
The following adapters are supported by TROCCO.
* Google BigQuery
* Snowflake
* Amazon Redshift

Was this article helpful?