topic How not to use the root location for the Databricks database with QCDI? in Data Movement & Streaming https://community.qlik.com/t5/Data-Movement-Streaming/How-not-to-use-the-root-location-for-the-Databricks-database/m-p/2071406#M992 <P>I am setting up Qlik Cloud Data Integration with Azure Databricks &amp; Azure Data Lake. My landing data assets are stored in the configured Azure Data Lake container.&nbsp;The tables generated by the storage, transform &amp; data mart data assets are however stored on the root&nbsp;<SPAN>&nbsp;location (/Usr/Hive/Warehouse/) of the Databricks database. I would like to store these to non-managed tables instead.</SPAN></P> <P>According to the Qlik Help page: "Best practice is<SPAN>&nbsp;</SPAN><I>not</I><SPAN>&nbsp;</SPAN>to use the root location (/Usr/Hive/Warehouse/) for the Databricks database as doing so may impact performance."</P> <P>However, I was unable to find an answer on how this best practice could then be implemented. Anyone an idea on how this could be configured?</P> Wed, 19 Mar 2025 23:04:08 GMT rlesage 2025-03-19T23:04:08Z How not to use the root location for the Databricks database with QCDI? https://community.qlik.com/t5/Data-Movement-Streaming/How-not-to-use-the-root-location-for-the-Databricks-database/m-p/2071406#M992 <P>I am setting up Qlik Cloud Data Integration with Azure Databricks &amp; Azure Data Lake. My landing data assets are stored in the configured Azure Data Lake container.&nbsp;The tables generated by the storage, transform &amp; data mart data assets are however stored on the root&nbsp;<SPAN>&nbsp;location (/Usr/Hive/Warehouse/) of the Databricks database. I would like to store these to non-managed tables instead.</SPAN></P> <P>According to the Qlik Help page: "Best practice is<SPAN>&nbsp;</SPAN><I>not</I><SPAN>&nbsp;</SPAN>to use the root location (/Usr/Hive/Warehouse/) for the Databricks database as doing so may impact performance."</P> <P>However, I was unable to find an answer on how this best practice could then be implemented. Anyone an idea on how this could be configured?</P> Wed, 19 Mar 2025 23:04:08 GMT https://community.qlik.com/t5/Data-Movement-Streaming/How-not-to-use-the-root-location-for-the-Databricks-database/m-p/2071406#M992 rlesage 2025-03-19T23:04:08Z