Datahub SQL Column Lineage With Transformation Logic Snowflake SQL Query

15 Views Asked by At

Suppose I have a SQL in snowflake like this

INSERT INTO EMPLOYEE
(NAME, ADDRESS, ZIP)
FROM 
SELECT F_NAME+L_NAME AS NAME, 
SUBSTRING(FULL_ADDRESS,1,100),
ZIP 
FROM 
SOURCE_DATA;

How can I get lineage in datahub like

F_NAME+L_NAME ----> NAME

SUBSTRINT(FULL_ADDRESS,1,100) ----> ADDRESS

ZIP ----> ZIP

0

There are 0 best solutions below