Snowflake provides the ACCESS_HISTORY view to track both read and write operations performed on tables (and other objects) within your account.
ACCESS_HISTORY records every query’s access details, including reads (direct_objects_accessed and base_objects_accessed) and writes (objects_modified) for operations such as INSERT, UPDATE, DELETE, and COPY.
It retains up to 365 days of history in the ACCOUNT_USAGE schema (Enterprise Edition or higher), enabling auditing and compliance reporting on who accessed or modified your data.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1 week ago