Comment on page
Getting Started

https://www.sqlflow.cn/gudu-sqlflow-introduction
Let's analyze the following SQL statements to see how to get the data dependencies between tables/views.
Tips:
You need to have basic SQL knowledge to understand this doc.
No data lineage knowledge is required before you start this doc. You can simply consider data lineage as the data relationship between tables in database.
INSERT INTO deptsal
            (dept_no,
             dept_name,
             salary)
SELECT d.deptno,
       d.dname,
       SUM(e.sal + Nvl(e.comm, 0)) AS sal
FROM   dept d
       left join (SELECT *
                  FROM   emp
                  WHERE  hiredate > DATE '1980-01-01') e
              ON e.deptno = d.deptno
GROUP  BY d.deptno,
          d.dname; 
Data of the table deptsal come from the table dept and the table emp. More specifically, following data lineage relationship can be deduced:
deptsal.dept_no field comes from dept.deptno
deptsal.dept_name field comes from dept.name
deptsal.salary field comes from emp.sal and emp.comm
Through Gudu SQLFlow, we can visualize the above data lineage as:
What's next?
​Sign up a new Gudu account​
Learn how to use SQLFlow​
Read more about Gudu SQLFlow UI​
Install a SQLFlow Server​
Use SQLFlow Java Library​
Analyze your data through Rest API​
​Understand the format of exported data as well as check our sample data:
​Oracle Sample​
​MSSQL Sample​
​MySQL Sample​
​PostgreSQL Sample​
Get more details about the data model.
Cloud and On-Premise version
Last modified 1yr ago