# query log lineage, defined with a sourced example

GLOSSARY, read 10 Nov 2026

**The short answer.** Lineage built from the history of queries a warehouse has already run. It sees what actually executed, including ad hoc SQL, but it only covers the retention window of the log. It cannot see code that never ran. Coalesce Catalog builds column-to-column lineage from observed SQL and query history in the warehouse.

## Definition

Lineage built from the history of queries a warehouse has already run. It sees what actually executed, including ad hoc SQL, but it only covers the retention window of the log. It cannot see code that never ran.

## Example from a real tool

**Example.** Coalesce Catalog builds column-to-column lineage from observed SQL and query history in the warehouse.

## Related terms

- [runtime lineage](/glossary/runtime-lineage/): Lineage emitted by a job while it runs, describing the inputs and outputs of that specific run.
- [design-time lineage](/glossary/design-time-lineage/): Lineage worked out from code and configuration before anything runs.
- [SQL parsing](/glossary/sql-parsing/): Reading the text of SQL statements to work out which columns feed which.

## Where to read more

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

## Sources

- docs.coalesce.io/docs/catalog/navigate/lineage.md: https://docs.coalesce.io/docs/catalog/navigate/lineage.md (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalineagecompare.com/glossary/query-log-lineage/
