See why hundreds of industry leaders trust Secoda to unlock their data's full potential.
See why hundreds of industry leaders trust Secoda to unlock their data's full potential.
Get the guideInstalling the dbt-trino adapter plugin is the first step in connecting Starburst or Trino to dbt. This plugin enables dbt to interact with the Starburst or Trino clusters. The installation process is straightforward and can be done using pip, a package installer for Python.
pip install dbt-trino
This command installs the dbt-trino adapter plugin. Once installed, you can use dbt with your Starburst or Trino clusters.
After installing the dbt-trino adapter, the next step is to configure the connection details in the profiles.yml file. This file contains the necessary information for dbt to connect to your Starburst or Trino clusters.
profiles.yml:
target: dev
outputs:
dev:
type: trino
host: your-cluster-hostname
port: your-cluster-port
user: your-username
password: your-password
database: your-database
schema: your-schema
This code block represents a sample configuration in the profiles.yml file. Replace the placeholders with your actual connection details.
When selecting the catalog and schema, it's crucial to ensure that the user has read and write access to both. These selections set the default location for materialized tables and views but do not limit querying other areas.
No specific code is required for this step. It involves checking access permissions in your Starburst or Trino cluster.
Ensuring proper access to the catalog and schema is more of a configuration and permission setting task rather than a coding task. It involves checking and setting permissions in your Starburst or Trino cluster.
If you are connecting to a Starburst Enterprise cluster with access controls, you must specify a role using the format catalog: role in your profiles.yml file.
profiles.yml:
target: dev
outputs:
dev:
type: trino
host: your-cluster-hostname
port: your-cluster-port
user: your-username
password: your-password
database: your-database
schema: your-schema
role: your-role
This code block represents a sample configuration in the profiles.yml file for a Starburst Enterprise cluster. The role field is added to specify the user's role.
For dbt Cloud users, there's no need to create a profiles.yml file. Instead, you can configure the connection details directly in the dbt Cloud UI.
No specific code is required for this step. It involves configuring settings in the dbt Cloud UI.
Configuring connection details in dbt Cloud UI is a straightforward process. It involves navigating to the settings page in dbt Cloud and entering your connection details.
Built for data teams, designed for everyone so you can get more from your data stack.
© 2024 Secoda, Inc. All rights reserved.
By using this website, you accept our Terms of Use and Privacy Policy.
