SQLText Editor

Enter your SQL code in the live editor. You can choose the database under the section of dbvendor. Visualize your data lineage by clicking visualize or visualize join.

Table level lineage

Click Table Lineage to show only table level lineage. UI invokes /sqlflow/graph/table_level_lineage to get the table level lineage result. The /sqlflow/graph/table_level_lineage returns the simplified data lineage result with only table level information.

Table level lineage has almost the same structure as column level lineage. The only difference is instead of pointing to table, the source block or the target block will point to process.

Example:

relation(process E), column A.b --> column C.d

will become

table A ---> process E --> table C

You can read more about relationship, source, target here.

Check source sql code under table level lineage

Visualize join

When clicking visualize, a sqlflow model will be generated and the UI will display the data lineage based on the sqlflow model response. A request to /sqlflow/generation/sqlflow/graph will be made with fdd as the value of the field showRelationType and true in ignoreFunction.

When clicking visualize join, same endpoint (/sqlflow/generation/sqlflow/graph) will be invoked as above. We will have join as the value of the field showRelationType and true for ignoreFunction in the request.