Join Starburst on March 18th for the next iteration of our Live Demo Series

New release of the dbt-trino adapter

  • Barton Wright

    Barton Wright

    Information Engineer, Technical Lead

    Starburst

  • Przemek Denkiewicz

    Przemek Denkiewicz

    Senior Software Engineer

    Starburst

  • Michiel De Smet

    Michiel De Smet

    Software Engineer

    Starburst

  • Manfred Moser

    Manfred Moser

    Director of Technical Content

    Starburst

Share

Linkedin iconFacebook iconTwitter icon

dbt labs released version 1.1 of the dbt-core project in late April, 2022. This did not catch the maintainers of the dbt-trino project by surprise. We have been hard at work adding features and fixing bugs, and are proud to announce version 1.1 of the dbt-trino adapter.

Install the new version, and any necessary dependencies, with the following command:

pip install dbt-trino==1.1.0

The most important new feature in dbt-trino 1.1 is support for OAuth2 authentication using a web browser. This lets you log in to a cluster using the credentials from an OAuth2-compatible single sign-on system. To use this feature, install the keyring package to cache the OAuth2 token over multiple dbt invocations, and make sure you have the trino package’s external auth token cache feature.

pip install 'trino[external-authentication-token-cache]'

Other new features of dbt-trino 1.1 include:

  • Improved data type mapping.
  • Support for on_table_exists in table materialization.
  • Support for view_security to define the security mode for views.

For those developing dbt-trino or extensions based on it, the 1.1 release includes:

  • Migration of the GitHub project to a new adapter testing framework.
  • Adding a PostgreSQL Docker container for testing.

See these pages for more on using dbt with Trino or Starburst.

Barton, Przemek, Michiel, and Manfred

Cookie Notice

This site uses cookies for performance, analytics, personalization and advertising purposes. For more information about how we use cookies please see our Cookie Policy.

Manage Consent Preferences

Essential/Strictly Necessary Cookies

Required

These cookies are essential in order to enable you to move around the website and use its features, such as accessing secure areas of the website.

Analytical/Performance Cookies

These are analytics cookies that allow us to collect information about how visitors use a website, for instance which pages visitors go to most often, and if they get error messages from web pages.

Functional/Preference Cookies

These cookies allow our website to properly function and in particular will allow you to use its more personal features.

Targeting/Advertising Cookies

These cookies are used by third parties to build a profile of your interests and show you relevant adverts on other sites.