topic Re: not able to see access schema inside system catalog in Administration & Architecture

not able to see access schema inside system catalog

Kroy — Tue, 12 Mar 2024 14:49:14 GMT

Hi,

I am account admin role but not able to see access schema , I want to query audit log table

Re: not able to see access schema inside system catalog

Sravani-Vadali — Tue, 12 Mar 2024 20:08:44 GMT

Hi @Kroy! Are you not able to see the audit log table under the information_schema?

Re: not able to see access schema inside system catalog

Kroy — Wed, 13 Mar 2024 04:03:14 GMT

Hi,

Re: not able to see access schema inside system catalog

Ajay-Pandey — Wed, 13 Mar 2024 09:26:56 GMT

@Kroy You should need to enable the system.access schema then it will be visible to your catalog, please find below docs for enabling the same -

Audit log system table reference | Databricks on AWS

Monitor usage with system tables | Databricks on AWS

Re: not able to see access schema inside system catalog

Kroy — Wed, 13 Mar 2024 10:27:03 GMT

Done, needed to enable the system schema --

Run this command in notebook- to get list of available schema

%sh

curl -v -X GET -H "Authorization: Bearer <PAT Token>" "https://adb-<xxx>.azuredatabricks.net/api/2.0/unity-catalog/metastores/<metastore-id>/systemschemas"

state: AVAILABLE: The system schema is available but has not yet been enabled.

state: EnableCompleted: You have enabled the system schema and it is visible in Catalog Explorer.

To enable any schema

%sh

curl -v -X DELETE -H "Authorization: Bearer <PAT Token>" "https://adb-<xxx>.azuredatabricks.net/api/2.0/unity-catalog/metastores/<metastore-id>/systemschemas/<SCHEMA_NAME>"