dbt-databricks icon indicating copy to clipboard operation
dbt-databricks copied to clipboard

macro create schema should support a location

Open mvdwielen opened this issue 2 years ago • 2 comments

dbt-databricks should override the default dbt create_schema(relation) macro in such a location of the schema (and the tables within the schema) can be provided. This way the schema and tables can be stored on an external location like an ADLS storage account. This way the schema and tables within the schema become managed in such the physical data of the schema and tables will be deleted as well when the schema and / or tables are dropped.

mvdwielen avatar Mar 03 '23 09:03 mvdwielen

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue.

github-actions[bot] avatar Aug 31 '23 01:08 github-actions[bot]

Reactivating this issue. Also, should be able to specify whether tables created under that schema should be external or managed.

benc-db avatar Mar 15 '24 14:03 benc-db