dbt-trino

What it is and what it does

dbt-trino is a dbt adapter that bridges dbt projects to Trino, a distributed SQL query engine. It allows you to define data transformations in dbt SQL and have Trino execute them across multiple heterogeneous data sources—databases, data lakes, and other systems—without moving data between them. This is query federation: Trino translates your SQL to the native dialects of each underlying source and orchestrates the results.

The adapter is a fork of dbt-presto adapted for Trino's connector ecosystem. It handles the translation between dbt's transformation model and Trino's execution layer, letting teams use dbt's modularity, testing, and CI/CD practices while leveraging Trino's ability to query across disparate systems in a single project. It supports Python 3.9 through 3.13 and is actively maintained.

Use it for:

• Build a single dbt project that transforms data across multiple internal databases via Trino connectors without ETL.
• Federate queries across disparate data sources using dbt models to define transformation logic.
• Migrate analytics workflows from dbt-presto to Trino while keeping existing dbt projects intact.
• Test and document SQL transformations that span multiple data sources before materializing results.
• Implement CI/CD pipelines for data transformations that run against a Trino cluster in a staging environment.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A dbt adapter that connects dbt projects to Trino, enabling SQL-based data transformations across multiple federated data sources through a single connection.

Yes, if you use Trino or Starburst and want to manage multi-source SQL transformations with dbt. The adapter is production-stable, actively maintained, has no known vulnerabilities, and low install friction. Install it if your data architecture relies on query federation; skip it if you work with a single warehouse or don't use dbt.

Install

dbt-trino on PyPI

pip install dbt-trino

uv add dbt-trino

poetry add dbt-trino

Installing dbt-trino

Before you install

Low friction installation as a pure Python wheel. Actively maintained with a release 18 days ago and ongoing commits. Supports Python 3.9, 3.10, 3.11, 3.12, 3.13 and is marked Production/Stable.

License in practice

Apache License 2.0 (permissive) allows commercial use, modification, and distribution with minimal restrictions—standard for data tools and compatible with most enterprise environments.

Quickstart

pip install dbt-trino

In profiles.yml:
my_trino_db:
  target: dev
  outputs:
    dev:
      type: trino
      host: [trino-host]
      port: [port]
      user: [username]
      database: [database]
      schema: [schema]

Then: dbt run

Requires a running Trino or Starburst instance accessible over the network; dbt-core and its dependencies must also be installed.

Verify before relying

• Whether the adapter supports all Trino connectors or only a subset of available connectors.
• Performance characteristics and query optimization strategies when working with large federated datasets across many sources.
• Specific version compatibility guarantees beyond tested versions 478 (Trino) and 477-e.1 (Starburst Enterprise).

Package facts

Evidence: dbt_trino-1.10.3-py3-none-any.whl

Tags

More Front-Ends packages