About dbt linkage

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.
• It can connect to the corresponding data warehouse and execute queries against the tables in the data warehouse.
• Automated testing can also be performed during the query execution phase.

For more information, see the official dbt page.

TROCCO's dbt linkage

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

dbt supported version

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 Setting

Supported adapters

In dbt, the data warehouse that dbt supports is denoted by the term adapter.
TROCCO supports the following adapters

• Google BigQuery
• Snowflake
• Amazon Redshift