Comment on page
Architecture Overview
https://github.com/sqlparser/sqlflow_public/blob/master/sqlflow_architecture.md


SQLFlow frontend
- 1.Send the SQL script received from the browser to the backend.
- 2.After receiving the result, visualize the diagram model in the browser and show the data lineage and diagram model generated by the backend.
- 3.Highlight the dataflow in the diagram when the user clicks on a specific table/column.
SQLFlow backend
- 1.
SQLFlow-Analyzer
: receiving the SQL script from the frontend and parse the SQL script into parsed tree nodes with the GSP library, calculating the data lineage by analyzing AST.TheSQLFlow-Analyzer
component can be executed as a standalone tool. Take SQL text as input and generate data lineage in JSON format. Check Java Library for more Info. - 2.
FlowLayout
: Calculating the layout of database objects(table/column) in the dlineage and generate the diagram model with all necessary position data, including nodes and edges.FlowLayout
depends ondoLayout library
to layout the database objects. - 3.Return a JSON snippet including the data lineage and diagram model to the frontend.
Last modified 1yr ago