GET
/
api
/
v1
/
explore
/
db
/
{data_connection_id}
/
columns
/
{column_path}
/
upstreams
curl --request GET \
  --url https://app.datafold.com/api/v1/explore/db/{data_connection_id}/columns/{column_path}/upstreams \
  --header 'Authorization: <api-key>'
[
  {
    "name": "<string>",
    "table": {
      "name": "<string>",
      "path": [
        "<string>"
      ]
    },
    "type": "Column"
  }
]

Authorizations

Authorization
string
headerrequired

Use the 'Authorization' header with the format 'Key <api-key>'

Path Parameters

data_connection_id
integer
required

Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.

Required range: x > 1
column_path
string
required

Path to the column, e.g. db.schema.table.column. The path is case sensitive. If components of the path contain periods, they must be quoted: db.my_schema."www.mysite.com visits"."visit.id".

Query Parameters

max_depth
integer
default: 10

Maximum depth of the lineage to retrieve.

Required range: 1 < x < 100

Response

200 - application/json
name
string
required
table
object
required

Database table reference.

type
string
default: Column
Allowed value: "Column"