Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024 12:10 AM
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 ?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024 04:35 AM
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 >
)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024 05:40 AM
yes system table will have all details
AviralBhardwaj
