Analyze data linege from SQL files

Use /f parameter to specify a single SQL file, or use /d parameter to specfify a directory that inculdes multiple SQL files.

java -jar gudusoft.dlineage.jar /t mssql /f path_to_sql_file

An sample sql file could be:

INSERT INTO raw_customers (id, first_name, last_name) VALUES(0, '', '');

An output XML will be generated:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <process id="8" name="Query Insert-1" procedureName="batchQueries" queryHashId="04ebc5aec1a07e1db80b0bc798742875" type="sstinsert" coordinate="[1,1,0],[1,73,0]"/>
    <table id="4" name="raw_customers" type="table" processIds="8" coordinate="[1,13,0],[1,26,0]">
        <column id="5" name="id" coordinate="[1,28,0],[1,30,0]"/>
        <column id="6" name="first_name" coordinate="[1,32,0],[1,42,0]"/>
        <column id="7" name="last_name" coordinate="[1,44,0],[1,53,0]"/>

Some indications for the above resposne:

  • coordinate<x,y,z>: x is the correspond line number, y is the column number and z is the has code value of the file.

  • process: the type of the data lineage

  • name: table field name or sql name

Last updated