gorgeous-dinner-4055
09/22/2022, 11:13 PMgorgeous-dinner-4055
09/22/2022, 11:13 PMselect version, createdon from metadata_aspect_v2 where urn = "urn:li:dataset:(URN NAME HERE)" and aspect='upstreamLineage'
gorgeous-dinner-4055
09/22/2022, 11:14 PMreturns:
+---------+----------------------------+
| version | createdon |
+---------+----------------------------+
| 0 | 2022-08-19 08:05:43.900000 |
| 1 | 2022-04-09 00:42:35.781000 |
| 2 | 2022-04-28 08:07:35.735000 |
| 3 | 2022-08-16 08:07:22.181000 |
+---------+----------------------------+
gorgeous-dinner-4055
09/22/2022, 11:14 PMgorgeous-dinner-4055
09/22/2022, 11:15 PMgorgeous-dinner-4055
09/23/2022, 1:05 AMlastObserved
is updating for version 0, and it now contains the latest timestamp. So, without knowing what the code is doing, guessing that the lineage is ignoring lastObserved
in favor of max(version)
Does that seem right? If someone could point me to where to validate that, happy to contribute heregorgeous-dinner-4055
09/23/2022, 2:33 AMgorgeous-dinner-4055
09/23/2022, 3:46 PM