https://community.databricks.com/t5/data-engineering/is-it-possible-to-migrate-sql-objects-from-one-workspace-to/m-p/55579#M30372 <P>We have SQL Queries and dashboards in workspace dev_01. New workspace dev_02 is created and unity catalog is enabled.</P><P>I was able to migrate jobs, clusters, DLTs, SQL warehouses, users using APIs. But, while migrating queries using APIs, I can't get them to the same user folder as in dev_01. I am facing error saying 'no parent folder'. When I ignore this parameter, the queries are being created in my workspace folder instead of workspace of actual creator of that query. Is there a way to get queries into dev_02 and into same user folders as in dev_01?</P><P>The same question for SQL dashboards also. Is it possible to migrate them to dev_02 seemlessly?</P> Thu, 21 Dec 2023 04:41:59 GMT valjas 2023-12-21T04:41:59Z https://community.databricks.com/t5/data-engineering/is-it-possible-to-migrate-sql-objects-from-one-workspace-to/m-p/55579#M30372 <P>We have SQL Queries and dashboards in workspace dev_01. New workspace dev_02 is created and unity catalog is enabled.</P><P>I was able to migrate jobs, clusters, DLTs, SQL warehouses, users using APIs. But, while migrating queries using APIs, I can't get them to the same user folder as in dev_01. I am facing error saying 'no parent folder'. When I ignore this parameter, the queries are being created in my workspace folder instead of workspace of actual creator of that query. Is there a way to get queries into dev_02 and into same user folders as in dev_01?</P><P>The same question for SQL dashboards also. Is it possible to migrate them to dev_02 seemlessly?</P> Thu, 21 Dec 2023 04:41:59 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-migrate-sql-objects-from-one-workspace-to/m-p/55579#M30372 valjas 2023-12-21T04:41:59Z https://community.databricks.com/t5/data-engineering/is-it-possible-to-migrate-sql-objects-from-one-workspace-to/m-p/61160#M31725 <P>I'm doing something similar, but I haven't run into this parent directory issue. [Actually to be clear I ran into an issue around missing user directories, but I believe that was different than what you describe]. Before migrating the queries, I'm recreating the workspace directories from the original workspace within the new workspace (really I'm going from one tenant to another, but I believe our experiences are still the same). I then create a map between ids of corresponding directories and use this map to create queries in the correct corresponding directory.&nbsp; For the workspace directories I'm using these two endpoints:</P><OL><LI><A href="https://docs.databricks.com/api/workspace/workspace/list" target="_blank" rel="noopener">https://docs.databricks.com/api/workspace/workspace/list</A></LI><LI><A href="https://docs.databricks.com/api/workspace/workspace/mkdirs" target="_blank" rel="noopener">https://docs.databricks.com/api/workspace/workspace/mkdirs</A></LI></OL><P>You mentioned you are using APIs to move the queries, but just to be clear, I'm using these endpoints:</P><OL><LI><A href="https://docs.databricks.com/api/workspace/queries/list" target="_blank" rel="noopener">https://docs.databricks.com/api/workspace/queries/list</A></LI><LI><A href="https://docs.databricks.com/api/workspace/queries/create" target="_blank" rel="noopener">https://docs.databricks.com/api/workspace/queries/create</A></LI></OL><P>Are you doing something similar?&nbsp;</P> Mon, 19 Feb 2024 18:27:04 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-migrate-sql-objects-from-one-workspace-to/m-p/61160#M31725 jcoggs 2024-02-19T18:27:04Z