Source
QUERY_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.
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.
Access History
The user access history can be found by querying the ACCESS_HISTORY view in the ACCOUNT_USAGE and ORGANIZATION_USAGE schemas.
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…
QUERY_ATTRIBUTION_HISTORY view
This Account Usage view can be used to determine the compute cost of a given query run on warehouses in your account in the last 365 days (1 year). For more information, see Viewing cost by tag in SQL.
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,…
SNAPSHOT_OPERATION_HISTORY view — Deprecated
Latency for the view may be up to 360 minutes (6 hours). Snowflake retains the history data for 365 days (approximately one year).
COLUMN_QUERY_PRUNING_HISTORY view
Use this Account Usage view to gain a better understanding of data access patterns during query execution, including some column - level details, such as the “access type” and candidate search optimization expressions that are…