Member-only story

Enable the databricks system tables the quickest way

Hubert Dudek
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:

--

--

No responses yet