Enable system schemas

[OlekNV]

Hello All,

I'm new with Databricks,
Have an issue within enable system schemas. When run api call to check system schemas status in metastores -
I see that all schemas in "Unavailable" state (except "information_schema", which is "ENABLE_COMPLETED").
Is that possible to fix that? Maybe some configuration was not done on metastore level?

Thanks in advance!

[Kaniz_Fatma]

Hi @OlekNV, Here are a few things you could check:

Unity Catalog: System tables are governed by Unity Catalog, so you need to have at least one Unity C....

Enable System Tables: System tables must be enabled by an account admin. You can enable system tables using the Unity Catalog REST API.

Network Access: To enable system tables, you might need to grant network access to the system tables....

Schema Compatibility: There might be issues with schema compatibility. For instance, if you’re using the ‘wasbs’ schema, it might not function properly in the SQL editor. The legacy Windows Azure Storage Blob driver (WASB) has been deprecated and it’s recommended to use ....

Hope this helps! 😊

[OrvilleBruen]

Thanks for those links, you made my day.

[Kaniz_Fatma]

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!