Lineage Queries

select * from meta.l_get_origin_recursive(start_node_type, start_object_id) - returns recursive list of all origin nodes for the given start node, including path

 

select * from meta.l_get_destination_recursive(start_node_type, start_object_id) - returns recursive list of all destination nodes for the given start node, including path

 

Each query/function returns hierarchical list of objects in parent-child format, along with path column that contains visual data flow path

 

Type	Description	Object_id
R	raw attribute	raw_attribute_id
S	system	system_attribute_id
E	enrichment rule	enrichment_id
EA	enrichment aggregation	enrichment_aggregation_id
CM	column mapping	output_source_column_id
OC	output column	output_column_id