https://community.databricks.com/t5/data-engineering/disable-managed-tables-on-azure-databricks/m-p/19060#M12722 <P>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?</P> Fri, 25 Jun 2021 18:48:46 GMT User16826990884 2021-06-25T18:48:46Z https://community.databricks.com/t5/data-engineering/disable-managed-tables-on-azure-databricks/m-p/19060#M12722 <P>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?</P> Fri, 25 Jun 2021 18:48:46 GMT https://community.databricks.com/t5/data-engineering/disable-managed-tables-on-azure-databricks/m-p/19060#M12722 User16826990884 2021-06-25T18:48:46Z https://community.databricks.com/t5/data-engineering/disable-managed-tables-on-azure-databricks/m-p/19061#M12723 <P>Hi,</P><P></P><P>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:</P><P></P><P></P><P>"spark_conf.spark.sql.warehouse.dir": {</P><P>&nbsp;&nbsp;"type": "fixed",</P><P>&nbsp;&nbsp;"value": "abfss://mycontainer@mystorage.dfs.core.windows.net/myfolder/default_warehouse"</P><P>&nbsp;}</P> Wed, 29 Jun 2022 12:24:29 GMT https://community.databricks.com/t5/data-engineering/disable-managed-tables-on-azure-databricks/m-p/19061#M12723 florent 2022-06-29T12:24:29Z