Member-only story
Enable the databricks system tables the quickest way
Jan 11, 2025
Access for free via a friend’s link
Just attach the notebook to the serverless computing:
Please choose the newest version on the environment runtime as it comes with the latest version of the preinstalled databricks SDK.
Connect to workspace client (you must be an account admin):
from databricks.sdk import WorkspaceClient
w = WorkspaceClient()
Loop all tables and try to activate each of them:
for ss in w.system_schemas.list(metastore_id=w.metastores.current().metastore_id):
try:
print(ss.schema)
w.system_schemas.enable(metastore_id=w.metastores.current().metastore_id, schema_name=ss.schema)
except Exception as e:
print(f"Error enabling schema {ss.schema}: {e}")
After that, all should be active: