Overview Quickstart dbt Compatibility The Style Guide profiles.yml sources.yml Configuration Supported Databases

TRINO

Distributed SQL query engine for federated analytics across heterogeneous data sources. Formerly known as Presto.

DVT SUPPORT

✓ FEDERATION SOURCE

read in federation models

✓ FEDERATION TARGET

materialize federation results

✓ DEFAULT TARGET

run full dbt projects against it

✓ SEED TARGET

dvt seed --target loads here

DVT supports Trinobecause both dbt and Sling do: dbt drives standard materializations when it's your default target, Sling moves data in and out during federation. Connectivity for both layers is checked with dvt debug --all.

PREREQUISITES

Driver: trino — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `trino`
host	string	yes	—	Trino coordinator hostname
port	integer	no	8080	Coordinator port
user	string	yes	—	Trino username
catalog	string	yes	—	Catalog name (e.g., hive, iceberg)
schema	string	no	default	Default schema
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: trino_dev
  outputs:
    trino_dev:
      type: trino
      host: trino-coordinator.internal.com
      port: 8080
      user: analyst
      catalog: hive
      schema: default

SOURCES.YML EXAMPLE

sources:
  - name: data_lake
    meta:
      connection: trino_dev
    schema: raw
    tables:
      - name: web_logs
      - name: app_events

DBT ADAPTER FEATURES

When Trino is your default target, every standard dbt model runs through the official dbt adapter — all of its documented capabilities apply unchanged:

MATERIALIZATIONS

INCREMENTAL STRATEGIES

NOTABLE CONFIGS

▸multi-catalog queries
▸session properties
▸works with Starburst

Official dbt Trino adapter docs ↗

FEDERATION INCREMENTAL STRATEGIES

Strategies available when this engine is the target of a f_incremental model:

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠Authentication via host/Kerberos — no password in connection URL