How to Migrate Legacy Dashboards from hive_metastore to Unity Catalog using Python

Sudheer2
New Contributor III

Hi all,

After updating the legacy dashboard APIs, I’m looking to migrate legacy dashboards from the hive_metastore to Unity Catalog in Databricks. Specifically, I want to programmatically:

  • Migrate SQL queries used in dashboards

  • Retain or recreate the associated data visualizations

  • Ensure compatibility with Unity Catalog schemas/tables

  • Perform the migration using Python

Has anyone successfully done this, or is there any recommended approach or API support for this kind of end-to-end migration?

Appreciate any guidance, best practices, or script examples.

Thanks in advance!