/sqlflow/graph/table_level_lineage
Last updated
Last updated
{
"code": 200,
"data": {
"mode": "global",
"summary": {
"schema": 0,
"process": 0,
"database": 0,
"view": 0,
"mostRelationTables": [],
"column": 4,
"relationship": 0,
"table": 3
},
"sqlflow": {
"dbvendor": "dbvoracle",
"dbobjs": [
{
"id": "4",
"name": "EMP",
"type": "table",
"columns": [
{
"id": "5",
"name": "DEPTID",
"coordinates": [
{
"x": 1,
"y": 35,
"hashCode": "0"
},
{
"x": 1,
"y": 45,
"hashCode": "0"
}
]
},
{
"id": "17",
"name": "ENAME",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
],
"coordinates": [
{
"x": 1,
"y": 19,
"hashCode": "0"
},
{
"x": 1,
"y": 22,
"hashCode": "0"
}
]
},
{
"id": "9",
"name": "DEPT",
"type": "table",
"columns": [
{
"id": "10",
"name": "ID",
"coordinates": [
{
"x": 1,
"y": 48,
"hashCode": "0"
},
{
"x": 1,
"y": 55,
"hashCode": "0"
}
]
}
],
"coordinates": [
{
"x": 1,
"y": 24,
"hashCode": "0"
},
{
"x": 1,
"y": 28,
"hashCode": "0"
}
]
},
{
"id": "15",
"name": "PSEUDO_TABLE_INCLUDE_ORPHAN_COLUMN",
"type": "pseudoTable",
"columns": [
{
"id": "16",
"name": "ENAME",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
],
"coordinates": [
{
"x": 1,
"y": 1,
"hashCode": "0"
},
{
"x": 1,
"y": 35,
"hashCode": "0"
}
]
}
],
"relationships": [],
"errors": [
{
"errorMessage": "find orphan column(10500) near: ename(1,8)",
"errorType": "SyntaxHint",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
},
{
"errorMessage": "Link orphan column [ename] to the first table [emp]",
"errorType": "LinkOrphanColumn",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
]
},
"graph": {
"relationshipIdMap": {},
"elements": {
"tables": [],
"edges": []
},
"tooltip": {},
"listIdMap": {}
}
},
"sessionId": "1491a5d5071c220ab993aa4d8a2e0e477d83abe4dd976a0c5c56c69e886a9481_1667481872808"
}generate sqlflow table level lineage graph
/sqlflow/generation/sqlflow/graph/table_level_lineage
database vendor
dbvazuresql, dbvbigquery, dbvcouchbase, dbvdb2, dbvgreenplum, dbvhana, dbvhive, dbvimpala, dbvinformix, dbvmdx, dbvmysql, dbvnetezza, dbvopenedge, dbvoracle, dbvpostgresql, dbvredshift, dbvsnowflake, dbvmssql, dbvsparksql, dbvsybase, dbvteradata, dbvverticawhether ignore self lineage
give the job Id if need to use the job settings and display the job graph
whether normalize the Identifier
sql text from which to generate the sqlflow model
The token is generated from userid and usersecret. It is used in every Api invocation.
user id
sql file from which to generate the sqlflow model
curl -L \
--request POST \
--url 'https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/graph/table_level_lineage?dbvendor=dbvoracle&token=text&userId=text' \
--header 'Content-Type: multipart/form-data'{
"code": 200,
"sessionId": "1491a5d5071c220ab993aa4d8a2e0e477d83abe4dd976a0c5c56c69e886a9481_1667481872808",
"data": {
"mode": "global",
"summary": {
"schema": 0,
"process": 0,
"database": 0,
"view": 0,
"column": 4,
"relationship": 0,
"table": 3,
"mostRelationTables": []
},
"graph": {
"relationshipIdMap": {},
"tooltip": {},
"listIdMap": {},
"elements": {
"tables": [],
"edges": []
}
},
"sqlflow": {
"dbvendor": "dbvoracle",
"relationships": [],
"errors": [
{
"errorMessage": "find orphan column(10500) near: ename(1,8)",
"errorType": "SyntaxHint",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
},
{
"errorMessage": "Link orphan column [ename] to the first table [emp]",
"errorType": "LinkOrphanColumn",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
],
"dbobjs": [
{
"id": "4",
"name": "EMP",
"type": "table",
"coordinates": [
{
"x": 1,
"y": 19,
"hashCode": "0"
},
{
"x": 1,
"y": 22,
"hashCode": "0"
}
],
"columns": [
{
"id": "5",
"name": "DEPTID",
"coordinates": [
{
"x": 1,
"y": 35,
"hashCode": "0"
},
{
"x": 1,
"y": 45,
"hashCode": "0"
}
]
},
{
"id": "17",
"name": "ENAME",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
]
},
{
"id": "9",
"name": "DEPT",
"type": "table",
"coordinates": [
{
"x": 1,
"y": 24,
"hashCode": "0"
},
{
"x": 1,
"y": 28,
"hashCode": "0"
}
],
"columns": [
{
"id": "10",
"name": "ID",
"coordinates": [
{
"x": 1,
"y": 48,
"hashCode": "0"
},
{
"x": 1,
"y": 55,
"hashCode": "0"
}
]
}
]
},
{
"id": "15",
"name": "PSEUDO_TABLE_INCLUDE_ORPHAN_COLUMN",
"type": "pseudoTable",
"coordinates": [
{
"x": 1,
"y": 1,
"hashCode": "0"
},
{
"x": 1,
"y": 35,
"hashCode": "0"
}
],
"columns": [
{
"id": "16",
"name": "ENAME",
"coordinates": [
{
"x": 1,
"y": 8,
"hashCode": "0"
},
{
"x": 1,
"y": 13,
"hashCode": "0"
}
]
}
]
}
]
}
}
}OK