Unable to access all schemas in system catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2023 03:06 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 12:36 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 01:36 AM
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-west1I get the same error for another workspace in ap-southeast1 region.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 09:31 AM
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!!
Sanket
