not able to see access schema inside system catalog

[Kroy]

Hi,

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

[Sravani-Vadali]

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

[Kroy]

Hi,

No 

[Ajay-Pandey · Accepted solution]

@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

[Kroy · Accepted solution]

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