SQLText Editor
Last updated
Last updated
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 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:
will become
Click the dbvendor menu and select the database. Click sample SQL to get the sample sql corresponding to this dbvendor in the live editing box.
Hover over sqltext to find the corresponding graph.
Hover over graph to find the corresponding sqltext.
Hover over the edge of the panel. You can drag and change the width when there is a highlight.
Click a column in the graph to fix the upstream and downstream relationships. Press and hold down the left mouse button to move the canvas.
Click Table Lineage to show only table level lineage. UI invokes to get the table level lineage result. The returns the simplified data lineage result with only table level information.
You can read more about relationship, source, target .
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 will be made with fdd as the value of the field showRelationType and true in ignoreFunction.
When clicking visualize join, same endpoint () will be invoked as above. We will have join as the value of the field showRelationType and true for ignoreFunction in the request.
