Contents x
    About dbt linkage
    • 17 Jul 2024
    • Print
    • PDF
    Contents

    About dbt linkage

    • Updated on 17 Jul 2024
    • Print
    • PDF
    Article summary

    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?
    What's Next