# ACCESS_HISTORY, defined with a sourced example

GLOSSARY, read 10 Nov 2026

**The short answer.** 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. Snowflake's ACCESS_HISTORY records objects, including columns, accessed within the last 365 days.

## 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_LINEAGE](/glossary/get-lineage/): A Snowflake SQL function that returns upstream or downstream lineage for an object.
- [Unity Catalog lineage](/glossary/unity-catalog-lineage/): The lineage Databricks captures for tables registered in Unity Catalog.
- [ref() in dbt](/glossary/ref-in-dbt/): The dbt function one model uses to point at another, as in ref('model_a').

## Where to read more

- [The Lineage Depth Matrix](/matrix/)
- [All glossary terms](/glossary/)

## Sources

- docs.snowflake.com/en/sql-reference/account-usage/access_history.md: https://docs.snowflake.com/en/sql-reference/account-usage/access_history.md (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalineagecompare.com/glossary/access-history/
