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

 

 

Ajay Kumar Pandey

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

Sravani-Vadali
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

 

 

Ajay Kumar Pandey

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

 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group