https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25576#M17813 <P>Actually I plan to do video about that so stay tuned <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 17 Mar 2022 16:53:54 GMT Hubert-Dudek 2022-03-17T16:53:54Z https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25573#M17810 <P>Currently we're on an azure databricks workspace, we've setup during the POC, a long time ago. In the meanwhile we have built quite a production workload above databricks.</P><P>Now we want to split workspaces - one for analysts and one for data engineering as adviced by Azure. And we need an external metastore as a common metastore for both</P><P></P><P>I know I can create a new workspace with a new external metastore , but what I need is to migrate the existing one. How can this be achieved? </P> Mon, 14 Mar 2022 21:42:21 GMT https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25573#M17810 alonisser 2022-03-14T21:42:21Z https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25574#M17811 <P>From databricks notebook just run mysqldump. Server address and details you can take from logs or configuration.</P><P></P><P>I am including also link to example notebook <A href="https://docs.microsoft.com/en-us/azure/databricks/kb/_static/notebooks/2016-election-tweets.html" target="test_blank">https://docs.microsoft.com/en-us/azure/databricks/kb/_static/notebooks/2016-election-tweets.html</A></P> Mon, 14 Mar 2022 22:30:36 GMT https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25574#M17811 Hubert-Dudek 2022-03-14T22:30:36Z https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25575#M17812 <P>Wow thanks for that. I'll try this.</P> Thu, 17 Mar 2022 15:58:23 GMT https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25575#M17812 alonisser 2022-03-17T15:58:23Z https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25576#M17813 <P>Actually I plan to do video about that so stay tuned <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 17 Mar 2022 16:53:54 GMT https://community.databricks.com/t5/data-engineering/how-to-migrate-an-existing-workspace-for-an-external-metastore/m-p/25576#M17813 Hubert-Dudek 2022-03-17T16:53:54Z