dbt cloud Databricks Unity Catalog

Help
,
1

With dbt Cloud, how can I specifiy a “catalog” value so the materialised table is written into a desired Databricks Unity Catalog?

I tried the following in a model SQL but it still wrote the table into the default “hive_metastore” instead of the desired ‘main’ catalog:

{{config(
materialized=‘table’,
catalog=‘main’,
schema='dbt_abc,
file_format=‘delta’,
location_root=‘abfss://some_values’
)}}

Update (2022-11-08 21:30 UTC): is it becasue “dbt-databricks” adapter does not yet support “DBT Cloud”? If so, does anyone know when it will be available in “DBT Cloud”?

2

It’s available now, Introducing a Native, High-performance Integration With dbt Cloud

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.