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_existsin table materialization. - Support for
view_securityto 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