---
id: dbt-trino
version: "1.10.3"
license: Apache License 2.0
license_treatment: permissive
maintenance: active
---

# dbt-trino — The trino adapter plugin for dbt (data build tool)

License: permissive · Maintenance: active · Downloads: 768.4K/mo

## 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 above — 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

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

- License: Apache License 2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 768.4K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt trino adapter, trino data transformation, federated query dbt, dbt multi-source connector, trino sql adapter dbt, data transformation trino, query federation dbt, dbt-adapter, query-federation, trino

[View on SkillFed](https://skillfed.io/packages/dbt-trino) · [View on PyPI](https://pypi.org/project/dbt-trino/)