cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

not able to see access schema inside system catalog

Kroy
Contributor

Hi,

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

Kroy_0-1710254944077.png

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Ajay-Pandey
Esteemed Contributor III

@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

 

 

View solution in original post

Kroy
Contributor

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

 

View solution in original post

4 REPLIES 4

VVS29
New Contributor II
New Contributor II

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

Hi,

No 

Kroy_1-1710302587320.png

 

Ajay-Pandey
Esteemed Contributor III

@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 &#124; Databricks on AWS

Monitor usage with system tables &#124; Databricks on AWS

 

 

Kroy
Contributor

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

 

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!