How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
To determine which user has accessed a database object that contains sensitive information, an administrator should query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema. The ACCESS_HISTORY view provides detailed information about who accessed what data and when, including user activity on database objects. This is the most appropriate way to trace access to sensitive data within Snowflake.
https://theinformationlab.nl/2022/10/04/history-access-in-snowflake/