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

The correct answer is D. 365 days. The ACCESS_HISTORY view in the SNOWFLAKE.ACCOUNT_USAGE schema retains data for 365 days (D) - one full year. This view tracks which users accessed which data objects (tables, columns, stages) and when, supporting compliance, auditing, and data governance use cases. The 365-day…

Data Governance

Question

Options

A7 days
B14 days
C28 days
D365 days

How the community answered

(39 responses)

A
5% (2)
B
3% (1)
C
3% (1)
D
90% (35)

Explanation

The ACCESS_HISTORY view in the SNOWFLAKE.ACCOUNT_USAGE schema retains data for 365 days (D) - one full year. This view tracks which users accessed which data objects (tables, columns, stages) and when, supporting compliance, auditing, and data governance use cases. The 365-day retention is notably longer than many other ACCOUNT_USAGE views (which often retain 14 days) due to the regulatory importance of access audit trails.

Topics

#ACCESS HISTORY view#Data retention#Auditing#Data governance

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice