The Lineage tab displays the relationships between a node and other nodes. You can view the node dependencies and the lineage parsed from the code of the node.
Dependencies
The Dependencies section displays node dependencies based on the current configuration. If the dependencies shown do not match your expectations, reconfigure them on the Properties tab.
Lineage
The Lineage section shows table-level data lineage parsed directly from the node's code — not from configuration. The diagram maps which upstream tables feed into the node and which downstream tables the node writes to.
For example, an ODPS SQL node that contains the following SQL:
INSERT OVERWRITE TABLE dw_user_info_all_d PARTITION (dt='${bdp.system.bizdate}')
SELECT COALESCE(a.uid, b.uid) AS uid
, b.gender
, b.age_range
, b.zodiac
, a.region
, a.device
, a.identity
, a.method
, a.url
, a.referer
, a.time
FROM (
SELECT *
FROM ods_log_info_d
WHERE dt = ${bdp.system.bizdate}
) a
LEFT OUTER JOIN (
SELECT *
FROM ods_user_info_d
WHERE dt = ${bdp.system.bizdate}
) b
ON a.uid = b.uid;DataWorks parses the SQL and generates the following lineage diagram. The results from ods_log_info_d and ods_user_info_d are joined on uid and written to dw_user_info_all_d.
