Disable managed tables on Azure Databricks

[User16826990884]

When a user creates a table without a path, it writes it as a managed table in the root bucket. Can this functionality be disabled so users are forced to provide a storage path and follow our organization best practices?

[florent]

Hi,

I couldn't find the option to turn it off. It might be worth banning dbfs. However, you can configure the default location using a cluster policy by adding the following configuration:

"spark_conf.spark.sql.warehouse.dir": {

  "type": "fixed",

  "value": "abfss://mycontainer@mystorage.dfs.core.windows.net/myfolder/default_warehouse"

 }