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

Authorizations

​
Authorization
string
header
required

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
​
include_tabular_nodes
boolean
default:true

Include Tables in the lineage calculation and in the output.

Response

Successful Response

  • Column
  • Table
​
name
string
required
​
table
object
required

Database table reference.

​
type
string
default:Column
Allowed value: "Column"