I am trying to migrate Databricks SQL Dashboards and Queries from one workspace to another.
Recently Databricks allows storing SQL objects in Workspace folders (https://docs.databricks.com/sql/user/workspace-browser/), but archiving the folder into dbc archive does not seem to include SQL objects (only works for notebooks).
The Databricks migration tool (https://github.com/databrickslabs/migrate) also does not seem to cater for SQL objects.
I think using Databricks API may work by retrieving/creating query definitions. And then retrieving/creating dashboard definitions. Has anyone tried this method? Or if anyone has successfully migrated their SQL objects?
Thanks in advance.