Unable to access all schemas in system catalog

[kartikaybagla]

https://docs.databricks.com/en/administration-guide/system-tables/index.html

Based on this documentation, there should be a bunch of schemas in the system catalog and when trying to list them all, I can only see the INFORMATION_SCHEMA in the system catalog. I am logged in as account admin and my workspace is Unity Catalog governed.

How do I enable access to the billing, compute and access schemas?

[kartikaybagla]

Hi @Retired_mod, thank you for replying. I tried enabling system tables using the Unity Catalog REST API but it only shows the Information Schema available and doesn't show any details for all the other schemas. I used an account admin credentials for doing this. How do I fix this issue?

[kartikaybagla]

More specifically, I get this error when using the REST API for the Unity Catalog:

Error enabling the schema `billing`: INVALID_PARAMETER_VALUE | Description: EnableSystemSchema billing is not a system-schema that is available in us-west1

 I get the same error for another workspace in ap-southeast1 region.

[SanketMehta]

Hi Team, If you have any particular solution for this, then please share as I am also unable to access any system tables I enabled in 2023 August now!!