topic Re: Lineage & Query history table in Administration & Architecture

Lineage & Query history table

MadMax_71_2 — Wed, 04 Feb 2026 10:30:08 GMT

Hi,

I’m trying to perform a join between the Lineage and Query History system tables. Initially, I assumed statement_id could be used as the join key, but that didn’t seem correct. I then noticed that joining statement_id with entity_run_id also appears to work, since both columns contain the same values - and in cases where statement_id is null, entity_run_id still has valid entries.

Can anyone confirm what key you used to join these two tables?

Re: Lineage & Query history table

szymon_dybczak — Wed, 04 Feb 2026 13:00:04 GMT

Hi @MadMax_71_2 ,

Check ERD diagram. Here you should find what's the correct key:

docs.databricks.com/aws/en/assets/images/system-tables-erd-690b80220d077015a023f90d59ff7560.svg

Re: Lineage & Query history table

MadMax_71_2 — Wed, 04 Feb 2026 14:01:00 GMT

This really helpful, much appreciated!