topic Re: How do we get user list who accessed specific table or view in Unity catalog for last 6 months in Administration & Architecture

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

saikrishna3390 — Tue, 30 Apr 2024 07:10:36 GMT

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 ?

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

PL_db — Tue, 30 Apr 2024 11:35:31 GMT

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 >

)

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

Aviral-Bhardwaj — Tue, 30 Apr 2024 12:40:37 GMT

yes system table will have all details