Updated on 2022-12-29 GMT+08:00

Querying Data Linage Graph at the Column Level

Function

This API is used to query data linage graph at the column level.

URI

GET /v1/{project_id}/sdg/server/relation/jobs/{job_id}/dbs/{table_id}/columns

Table 1 Path Parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID

job_id

Yes

String

Task ID

table_id

Yes

String

Table ID

Table 2 Query Parameters

Parameter

Mandatory

Type

Description

assets_name

No

String

Asset name

risk_start

Yes

Integer

Start risk level

risk_end

Yes

Integer

End risk level

offset

No

Integer

Page number

limit

No

Integer

Page limit

Request Parameters

None

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

total

Integer

Total number of relationships

column_list

Array of RelationSimpleInfo objects

Relationship list

Table 4 RelationSimpleInfo

Parameter

Type

Description

id

String

Relationship ID

name

String

Relationship name

path

String

Relationship path

risk_level

Integer

Risk level

type

String

Relationship type

Status code: 400

Table 5 Response body parameters

Parameter

Type

Description

error_code

String

Error Code

error_msg

String

Error Message

Example Requests

Query data linage graph at the column level.

GET /v1/{project_id}/sdg/server/relation/jobs/{job_id}/dbs/{table_id}/columns

Example Responses

Status code: 200

Request sent

{
  "column_list" : [ {
    "id" : "xxxxxxxxxxxx",
    "name" : "xxxx",
    "path" : "xxxxxxxxxxxx",
    "risk_level" : 2,
    "type" : "MySQL"
  } ],
  "total" : 1
}

Status code: 400

Invalid request

{
  "error_code" : "dsc.40000011",
  "error_msg" : "Invalid parameter"
}

Status Codes

Status Code

Description

200

Request sent

400

Invalid request

Error Codes

See Error Codes.