/sqlflow/exportFullLineageAsCsv

Export full lineage as CSV

Export the full lineage as CSV, this api is for query mode

export sqlflow full lineage as csv format

post

export sqlflow full lineage as csv format

Authorizations

Query parameters

dbvendorstring · enumRequired

db vendor

Default: dbvoraclePossible values:

delimiterstringOptional

delimiter of the values in CSV, default would be ','

Default: ,

export_include_tablestringOptional

export_include_table

sessionIdstringOptional

sessionId

showConstantTablebooleanOptional

showConstantTable

Default: false

sqltextstringOptional

sql text

tokenstringRequired

The token is generated from userid and usersecret. It is used in every Api invocation.

treatArgumentsInCountFunctionAsDirectDataflowbooleanOptional

Whether treat the arguments in COUNT function as direct Dataflow

Default: false

userIdstringRequired

user id

Body

sqlfilestring · binaryOptional

sqlfile

Responses

200

OK

application/json;charset=utf-8

Responsestring

201

Created

401

Unauthorized

403

Forbidden

404

Not Found

post

HTTPcURLJavaScriptPython

POST /api/gspLive_backend/sqlflow/generation/sqlflow/exportFullLineageAsCsv HTTP/1.1
Host: api.gudusoft.com
Authorization: YOUR_API_KEY
Content-Type: multipart/form-data
Accept: */*
Content-Length: 20

{
  "sqlfile": "binary"
}

text

Sample response:

A CSV file

source_db,source_schema,source_table,source_column,target_db,target_schema,target_table,target_column,relation_type,effect_type
DEFAULT,SCOTT,EMP,SAL,DEFAULT,DEFAULT,VSAL,Salary,fdd,create_view
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,SMALL_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,SMALL_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,SMALL_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,SMALL_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,SMALL_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,SMALL_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,MEDIUM_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,MEDIUM_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,MEDIUM_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,LARGE_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,LARGE_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,LARGE_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,LARGE_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,LARGE_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,LARGE_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,SPECIAL_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,SPECIAL_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,SPECIAL_ORDERS,CEM,fdd,insert
DEFAULT,SCOTT,EMP,DEPTNO,DEFAULT,DEFAULT,VSAL,Department,fdd,create_view

Try it out!