Trino Profile

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-trino

Maintained by: Community
Author: findinpath
Source: Github
Core version: v0.20.0 and newer
dbt Cloud: Not Supported
dbt Slack channel Link to channel

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]

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
  2. Incremental models
Edit this page