Source
QUERY_HISTORY view
If the query failed, then the query type may be UNKNOWN. session_id NUMBER Session that executed the statement. authn_event_id NUMBER ID for the event for the authentication of the user for this query. This ID corresponds to the value in…
QUERY_HISTORY view
If the query failed, then the query type may be UNKNOWN. session_id NUMBER Session that executed the statement. authn_event_id NUMBER ID for the event for the authentication of the user for this query.
ACCESS_HISTORY view
Access 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) within…
QUERY_ATTRIBUTION_HISTORY view
Latency for the view may be up to 24 hours. The QUERY_ATTRIBUTE_HISTORY view in the ACCOUNT_USAGE schema contains most of the same columns as the QUERY_ATTRIBUTE_HISTORY view in the ORGANIZATION_USAGE schema.
AGGREGATE_QUERY_HISTORY view
This Account Usage view enables you to monitor and track execution of statements over time. It contains similar data to the QUERY_HISTORY view but is aggregated in one - minute intervals for repeated SQL statements. You can use this view…
QUERY_HISTORY , QUERY_HISTORY_BY_*
You can use the QUERY_HISTORY family of table functions to query Snowflake query history along various dimensions: QUERY_HISTORY returns queries within a specified time range. QUERY_HISTORY_BY_SESSION returns queries within a specified…
Access History
The user access history can be found by querying the ACCESS_HISTORY view in the ACCOUNT_USAGE and ORGANIZATION_USAGE schemas.
ACCESS_HISTORY view
Feature Available in the organization account, which requires Enterprise Edition or higher. To inquire about upgrading, please contact Snowflake Support. Important This view is only available in the organization account.
AGGREGATE_ACCESS_HISTORY view
Unique ID to identify identical parameterized queries. See QUERY_PARAMETERIZED_HASH column. USER_NAME TEXT User who issued the query. CALLS NUMBER The number of times the access behavior occurred during the window of time specified by…
TABLE_QUERY_PRUNING_HISTORY view
Each row in this view represents the query pruning history for a specific table within a given time interval. The data is aggregated by time interval and includes information about the number of queries executed, partitions scanned,…