How long does Snowflake retain information in the ACCESS HISTORY view?

The ACCESSHISTORY view, located in the ACCOUNTUSAGE schema, is designed for long-term auditing of data access and modification. It retains historical data for 365 days (1 year). This view logs which columns were accessed in a read operation and which columns were modified in a write operation. The latency for data to appear in this view can be up to 180 minutes (3 hours). This extended retention period is essential for compliance, governance, and security analysis over an annual cycle.

A. 7 days: This is the data retention period for the LOGINHISTORY view, which tracks user login events.
B. 14 days: This is the data retention period for several other ACCOUNTUSAGE views, such as QUERYHISTORY and WAREHOUSEMETERINGHISTORY.
C. 28 days: This is not a standard retention period for the common ACCOUNTUSAGE history views.

1. Snowflake Documentation. (n.d.). ACCESSHISTORY View. Retrieved from https://docs.snowflake.com/en/sql-reference/account-usage/accesshistory.

Reference Point: The "Data Retention" section explicitly states, "The view displays the history of the last 365 days (1 year)."

2. Snowflake Documentation. (n.d.). Account Usage. Retrieved from https://docs.snowflake.com/en/sql-reference/account-usage.

Reference Point: The table summarizing views in the schema shows a "1 Year" retention for ACCESSHISTORY and contrasts it with the retention periods for other views like QUERYHISTORY (14 days) and LOGINHISTORY (7 days).