@RSingh - Thanks for the question and using MS Q&A platform.
This is a known limitation with Azure Databricks workspace with Premium (+ Role-based access controls).
Error message: Error: InvalidSkuForDefaultCatalog, Default Catalog selection is only available for Premium workspaces.
Cause: Databricks started to enable new premium workspaces for Unity Catalog automatically and after enabling a workspace for Unity Catalog, it cannot be reversed. If it has Unity Catalogenabled and unfortunately cannot be downgraded. This seems to be a feature limitation and a possible workaround would be to migrate to a new workspace in standard tier.
Resolution:
Since this is a Unity Catalog enabled workspace, it cannot be reversed and hence it is not possible to downgrade the workspace. you can only migrate the workspace to new or existing standard workspace.
- To migrate data between workspaces, you can use the Databricks Migration Tool, which allows you to migrate objects such as notebooks, cluster configurations, and jobs.
- You can also use tools such as MLflow to copy experiments, runs, and models.
- Additionally, there are scripts available on GitHub that can assist with the migration process.
For more details, refer to Automatic enablement of Unity Catalog and Databricks Migration Tool.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.