databricks / dbt-databricks

A dbt adapter for Databricks.
https://databricks.com
Apache License 2.0
226 stars 119 forks source link

Add behavior to compute external path from root/catalog/schema/identifier #812

Open benc-db opened 1 month ago

benc-db commented 1 month ago

Describe the feature

Provide a mechanism so that tables are written to external paths that match the structure in Databricks

Describe alternatives you've considered

Asked about the possibility of encoding this in yaml files with variables, not sure if this is currently possible

Additional context

The lack of this is currently a big pain in testing, where sometimes UC complains that a table already exists at the location (since we only use table identifier today).

Who will this benefit?

Anyone that uses external locations and does non-trivial work