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?