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:ย 

How do we get user list who accessed specific table or view in Unity catalog for last 6 months

saikrishna3390
New Contributor II

We have a business use case where we want to track users who accessed a specific table in Unity catalog for last 6 months . Is there a way where we can pull this data ? 

1 ACCEPTED SOLUTION

Accepted Solutions

PL_db
Contributor

You can pull this data from system tables

 
SELECT
*
FROM
system.access.audit
WHERE
service_name = "unityCatalog"
AND user_identity.email = < user email >
AND action_name = "getTable"
AND request_params.full_name_arg = < table name >
AND (
event_date BETWEEN < start_date >
AND < end_date >
)

View solution in original post

2 REPLIES 2

PL_db
Contributor

You can pull this data from system tables

 
SELECT
*
FROM
system.access.audit
WHERE
service_name = "unityCatalog"
AND user_identity.email = < user email >
AND action_name = "getTable"
AND request_params.full_name_arg = < table name >
AND (
event_date BETWEEN < start_date >
AND < end_date >
)

Aviral-Bhardwaj
Esteemed Contributor III

yes system table will have all details

AviralBhardwaj

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