Skip to main content

Starburst & Trino Profile

Vendor-supported plugin

Certain core functionality may vary. If you would like to report a bug, request a feature, or contribute, you can check out the linked repository and open an issue.

Overview of dbt-trino​

Maintained by: Starburst Data, Inc.
Source: Github
Core version: v0.20.0 and newer
dbt Cloud: Not Supported
dbt Slack channel: Slack

dbt-presto stars

Installation and Distribution​

dbt's Trino adapter is managed in its own repository, dbt-trino. To use the Trino adapter, you must install the dbt-trino plugin:

Using pip​

The following command will install the latest version of dbt-trino as well as the requisite version of dbt-core:

pip install dbt-trino

Set up a Trino Target​

Trino targets should be set up using the following configuration in your profiles.yml file.

~/.dbt/profiles.yml
trino:
  target: dev
  outputs:
    dev:
      type: trino
      method: none  # optional, one of {none | ldap | kerberos}
      user: [user]
      password: [password]  # required if method is ldap or kerberos
      database: [database name]
      host: [hostname]
      port: [port number]
      schema: [your dbt schema]
      threads: [1 or more]
      http_scheme: [http or https]
      session_properties:
        query_max_run_time: 5d
        exchange_compression: True

Incremental models​

The incremental strategy supported by the adapter is to append new records without updating/overwriting any existing data from the target model.

Caveats​

Unsupported Functionality​

Due to the nature of Trino, not all core dbt functionality is supported. The following features of dbt are not implemented on Trino:

  1. Snapshots