Apache Spark / Databricks: location_root = "external table"

[jtcohen6]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/resource-configs/spark-configs#configuring-tables

What part(s) of the page would you like to see updated?

https://docs.databricks.com/data-governance/unity-catalog/create-tables.html#external-tables

To create an external table with SQL, specify a LOCATION path in your CREATE TABLE statement.

If location_root is configured, dbt does specify a location path in the create table statement. That changes the created table from being "managed" to being "external," in the eyes of Spark/Databricks

Additional information

No response

[runleonarun]

@jtcohen6 Is this still something we want and do we want it fro both spark and databricks? I put it as low priority, but let me know if it's causing anyone heartburn and we can move it up inpriority!