topic Re: Unable to access all schemas in system catalog in Administration & Architecture

Unable to access all schemas in system catalog

kartikaybagla — Wed, 22 Nov 2023 11:06:19 GMT

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?

Re: Unable to access all schemas in system catalog

kartikaybagla — Thu, 23 Nov 2023 08:36:23 GMT

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?

Re: Unable to access all schemas in system catalog

kartikaybagla — Thu, 23 Nov 2023 09:36:06 GMT

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.

Re: Unable to access all schemas in system catalog

SanketMehta — Mon, 22 Jan 2024 17:31:36 GMT

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!!