Source
Access History
Access History in Snowflake refers to when the user query reads data and when the SQL statement performs a data write operation, such as INSERT, UPDATE, and DELETE along with variations of the COPY command, from the source data object to…
ACCESS_HISTORY viewCREATE or ALTER LISTING properties of OBJECT_MODIFIED_BY_DDLUsage Notes: Column Lineage
FeatureAvailable in the organization account, which requires Enterprise Edition or higher. To inquire about upgrading, please contact Snowflake Support. ImportantThis view is only available in the organization account.
AGGREGATE_ACCESS_HISTORY view
The AGGREGATE_ACCESS_HISTORY view contains similar data to the ACCESS_HISTORY view, aggregated over time for repeated queries in one - minute intervals. This view also provides access history information associated with both analytical and…
ACCESS_HISTORY viewCREATE or ALTER LISTING properties of OBJECT_MODIFIED_BY_DDLUsage Notes: Column Lineage
FeatureAccess History requires Enterprise Edition (or higher). To inquire about upgrading, please contact Snowflake Support. This Account Usage view can be used to query the access history of Snowflake objects (e.g. table, view, column)…
Dec 03, 2025: Access history improvements
Access history lets you monitor the SQL statements executed in Snowflake. It keeps track of the following types of statements: Data Manipulation Language (DML) statements. For example, statements used to insert data into a table.
Queries in Snowflake QUERY_HISTORY don't always show up in ACCESS_HISTORY view
Snowflake offers two valuable views to track user activity: Query History View (SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY): This view captures details about all executed queries, regardless of whether they interact with table data.
INGRESS_NETWORK_ACCESS_HISTORY view
This Account Usage view can be used to query any network access attempts to your Snowflake account within the last 365 days (1 year).
Feb 17, 2026: Access history improvements
Access history lets you monitor the SQL statements executed in Snowflake. It keeps track of the following types of statements: Data Manipulation Language (DML) statements. For example, statements used to insert data into a table.
CKE document access history
To help providers know which documents are being accessed in their Cortex Knowledge Extensions (CKE), Snowflake provides the following features: CKE access history data in the LISTING_ACCESS_HISTORY view in the SHARE_OBJECTS_ACCESSED…
Snowflake editions
To find your Snowflake edition by using SQL, query the ACCOUNTS view in the ORGANIZATION_USAGE schema, and select the edition column: Copy codeExpand code blockSELECT edition FROM SNOWFLAKE.