Access History

This topic documents how to use the ACCESS_HISTORY view to evaluate Snowflake objects.

In this Topic:

Understanding Access History

Access History in Snowflake refers to whether the user query reads column data. Snowflake does not record write operations. The user Access History can be found in the Access_History View (in this topic).

Each row in the ACCESS_HISTORY view contains a single record per query and describes the columns the query accessed directly (i.e. the base table) and indirectly (i.e. derived objects, such as views). These records facilitate regulatory compliance auditing and provide insights on popular and frequently accessed tables and columns since there is a direct link between the user (i.e. query operator), the query, the table or view, the column, and the data.

Additional use cases for the ACCESS_HISTORY view include:

  • Discovering unused data to determine whether to archive or delete the data.

  • Validating data changes to notify users prior to dropping or altering a given table or view.

  • Auditing data access to comply with regulatory requirements and data governance initiatives.

Access_History View

The Access History Account Usage view can be used to query the access history of Snowflake objects (e.g. table, view, column) within the last 365 days (1 year).

To obtain the user access history, query the ACCESS_HISTORY View.