Enter the sql into the input box, and then choose the database accordingly from the dbvendor menu, then click visualize or visualize join button to get a clear nice data lineage diagram.
Select the corresponding database.
Click sample sql button will load the sample SQL for the current selected database to the input box.
upload a single SQL file, or a zip file includes multiple SQL files for processing. A job will be created for the uploaded file.
click visualize button will call graph interface, and pass the following parameters： API used when click the button.
| name | value |
|---|---|
| sqltext | SQL query in the input box |
| dbvendor | database from the dbvendor menu |
| showRelationType | fdd |
| ignoreFunction | true |
click visualize join button will call graph interface, and pass the following parameters: API used when click the visualize join button.
| name | value |
|---|---|
| sqltext | SQL query in the input box |
| dbvendor | database from the dbvendor menu |
| showRelationType | join |
| ignoreFunction | true |
You have to login in order to upload a SQL or zip file for processing.
show the schema objects returned by the backend. you can select a schema/database/table and click the right mouse button to visualize the data lineage of the selected schema object.
- global, green color, means all data lineage information is returned for this object.
- summary, black color, means summary information returned for this object.
- ignore record, orange color, means data lineage is returned without intermediate result.
the color of DATAMART、DBO is orange, means the returned data linege doesn't include the intermediate result.
the color of LOAN is greeen, means all data lineage informaiton is returned.
node in gray means it's not visualized yet.
your can search database,schema,table,schema in the schema tree.
you can search database.schema.table.column ,schema.table,table.column or someting else like it. When you type dot, the schema tree will expand the next level.
set the graph interface：
| name | value |
|---|---|
| hideColumn | false/true，hide all columns |
| showRelationType | dataflow=true, impact=false, then value is fdd. dataflow=true, impact=true, the value is fdd,ddi,fdr,frd； if dataflow=false, impact=true, the value is: fddi,fdr,frd； |
| ignoreRecordSet | false/true，show intermediate recordset |
| ignoreFunction | false/true，show function |
click upload button to create a job by submit SQL text file or zip file including multiple SQL files or connect to a database.
export result to json or png file for download.
select a column to highlight the data flow, click cancel button to cancel the highlight.
right mouse click the menu item table lineage or column lineage to show the table or column relation, click cancel to back to the previous state.
SQLFlow frontend communicates with the backend using the RESTFul API /sqlflow/generation/sqlflow/graph。 Once it fetchs data from the backend, the frontend will analyze the graph and sqlflow and draw an interactive diagram accordingly.
Click the button or change the value in the setting panel will result in calling different API or call the same API with the different parameters, and get the different data from the backend consequence.
Reference：SQLFlow api doc
Reference：SQLFlow api doc
graph interfact： post /sqlflow/generation/sqlflow/graph