GLOSSARY, read 10 Nov 2026
ACCESS_HISTORY, defined with a sourced example
Definition
A Snowflake Account Usage view that records which objects, including columns, each query read and wrote. Lineage tools mine it to build column lineage inside Snowflake. Retention is limited, so history older than the window is not available.
Example from a real tool
Example
Snowflake's ACCESS_HISTORY records objects, including columns, accessed within the last 365 days.
Related terms
- GET_LINEAGEA Snowflake SQL function that returns upstream or downstream lineage for an object.
- Unity Catalog lineageThe lineage Databricks captures for tables registered in Unity Catalog.
- ref() in dbtThe dbt function one model uses to point at another, as in ref('model_a').
Where to read more
Sources
- docs.snowflake.com/en/sql-reference/account-usage/access_history.md, read 10 Nov 2026
Last reviewed 10 Nov 2026.