/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

export sqlflow full lineage as csv format

post

/sqlflow/generation/sqlflow/exportFullLineageAsCsv

Authorizations

Query parameters

dbvendorenumrequired

db vendor

Options: dbvazuresql, dbvbigquery, dbvcouchbase, dbvdb2, dbvgreenplum, dbvhana, dbvhive, dbvimpala, dbvinformix, dbvmdx, dbvmysql, dbvnetezza, dbvopenedge, dbvoracle, dbvpostgresql, dbvredshift, dbvsnowflake, dbvmssql, dbvsparksql, dbvsybase, dbvteradata, dbvvertica

delimiterstring

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

export_include_tablestring

export_include_table

sessionIdstring

sessionId

showConstantTableboolean

showConstantTable

sqltextstring

sql text

tokenstringrequired

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

treatArgumentsInCountFunctionAsDirectDataflowboolean

Whether treat the arguments in COUNT function as direct Dataflow

userIdstringrequired

user id

Body

sqlfilestring binary

sqlfile

Responses

application/json;charset=utf-8

cURL

JavaScript

Python

HTTP

cURL

curl -L \
  --request POST \
  --url 'https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/exportFullLineageAsCsv?dbvendor=dbvoracle&token=text&userId=text' \
  --header 'Authorization: YOUR_API_KEY' \
  --header 'Content-Type: multipart/form-data'

200

201

401

403

404

200

text

OK

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!