Datafold Explore API
The Explore API from Datafold — 4 operation(s) for explore.
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/datafold-explore-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
contact:
email: support@datafold.com
name: API Support
description: "The Datafold API reference is a guide to our available endpoints and authentication methods.\nIf you're just getting started with Datafold, we recommend first checking out our [documentation](https://docs.datafold.com).\n\n:::info\n To use the Datafold API, you should first create a Datafold API Key,\n which should be stored as a local environment variable named DATAFOLD_API_KEY.\n This can be set in your Datafold Cloud's Settings under the Account page.\n:::"
title: Datafold Audit Logs Explore API
version: latest
servers:
- description: Default server
url: https://app.datafold.com
security:
- ApiKeyAuth: []
tags:
- name: Explore
paths:
/api/v1/explore/db/{data_connection_id}/columns/{column_path}/downstreams:
get:
description: Retrieve a list of columns or tables which depend on the given column.
operationId: db_column_downstreams_api_v1_explore_db__data_connection_id__columns__column_path__downstreams_get
parameters:
- description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
in: path
name: data_connection_id
required: true
schema:
description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
minimum: 1
title: Data Connection ID
type: integer
- description: '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"`.'
in: path
name: column_path
required: true
schema:
description: '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"`.'
title: Table Column Path
type: string
- description: Maximum depth of the lineage to retrieve.
in: query
name: max_depth
required: false
schema:
default: 10
description: Maximum depth of the lineage to retrieve.
exclusiveMaximum: 100
minimum: 1
title: Max depth
type: integer
- description: Include Tables in the lineage calculation and in the output.
in: query
name: include_tabular_nodes
required: false
schema:
default: true
description: Include Tables in the lineage calculation and in the output.
title: Include tabular nodes
type: boolean
responses:
'200':
content:
application/json:
schema:
items:
anyOf:
- $ref: '#/components/schemas/Column'
- $ref: '#/components/schemas/Table'
title: Response Db Column Downstreams Api V1 Explore Db Data Connection Id Columns Column Path Downstreams Get
type: array
description: Successful Response
'422':
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
description: Validation Error
summary: Get column downstreams
tags:
- Explore
/api/v1/explore/db/{data_connection_id}/columns/{column_path}/upstreams:
get:
description: Retrieve a list of columns or tables which the given column depends on.
operationId: db_column_upstreams_api_v1_explore_db__data_connection_id__columns__column_path__upstreams_get
parameters:
- description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
in: path
name: data_connection_id
required: true
schema:
description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
minimum: 1
title: Data Connection ID
type: integer
- description: '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"`.'
in: path
name: column_path
required: true
schema:
description: '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"`.'
title: Table Column Path
type: string
- description: Maximum depth of the lineage to retrieve.
in: query
name: max_depth
required: false
schema:
default: 10
description: Maximum depth of the lineage to retrieve.
exclusiveMaximum: 100
minimum: 1
title: Max depth
type: integer
- description: Include Tables in the lineage calculation and in the output.
in: query
name: include_tabular_nodes
required: false
schema:
default: true
description: Include Tables in the lineage calculation and in the output.
title: Include tabular nodes
type: boolean
responses:
'200':
content:
application/json:
schema:
items:
anyOf:
- $ref: '#/components/schemas/Column'
- $ref: '#/components/schemas/Table'
title: Response Db Column Upstreams Api V1 Explore Db Data Connection Id Columns Column Path Upstreams Get
type: array
description: Successful Response
'422':
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
description: Validation Error
summary: Get column upstreams
tags:
- Explore
/api/v1/explore/db/{data_connection_id}/tables/{table_path}/downstreams:
get:
description: Retrieve a list of tables which depend on the given table.
operationId: db_table_downstreams_api_v1_explore_db__data_connection_id__tables__table_path__downstreams_get
parameters:
- description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
in: path
name: data_connection_id
required: true
schema:
description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
minimum: 1
title: Data Connection ID
type: integer
- description: 'Path to the table, e.g. `db.schema.table`. The path is case sensitive. If components of the path contain periods, they must be quoted: `db."my.schema"."www.mysite.com visits"`.'
in: path
name: table_path
required: true
schema:
description: 'Path to the table, e.g. `db.schema.table`. The path is case sensitive. If components of the path contain periods, they must be quoted: `db."my.schema"."www.mysite.com visits"`.'
title: Table Path
type: string
- description: Maximum depth of the lineage to retrieve.
in: query
name: max_depth
required: false
schema:
default: 10
description: Maximum depth of the lineage to retrieve.
exclusiveMaximum: 100
minimum: 1
title: Max depth
type: integer
responses:
'200':
content:
application/json:
schema:
items:
$ref: '#/components/schemas/Table'
title: Response Db Table Downstreams Api V1 Explore Db Data Connection Id Tables Table Path Downstreams Get
type: array
description: Successful Response
'422':
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
description: Validation Error
summary: Get table downstreams
tags:
- Explore
/api/v1/explore/db/{data_connection_id}/tables/{table_path}/upstreams:
get:
description: Retrieve a list of tables which the given table depends on.
operationId: db_table_upstreams_api_v1_explore_db__data_connection_id__tables__table_path__upstreams_get
parameters:
- description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
in: path
name: data_connection_id
required: true
schema:
description: Unique ID for the Data Connection. Can be found in the Datafold app under Settings > Integrations > Data Connections.
minimum: 1
title: Data Connection ID
type: integer
- description: 'Path to the table, e.g. `db.schema.table`. The path is case sensitive. If components of the path contain periods, they must be quoted: `db."my.schema"."www.mysite.com visits"`.'
in: path
name: table_path
required: true
schema:
description: 'Path to the table, e.g. `db.schema.table`. The path is case sensitive. If components of the path contain periods, they must be quoted: `db."my.schema"."www.mysite.com visits"`.'
title: Table Path
type: string
- description: Maximum depth of the lineage to retrieve.
in: query
name: max_depth
required: false
schema:
default: 10
description: Maximum depth of the lineage to retrieve.
exclusiveMaximum: 100
minimum: 1
title: Max depth
type: integer
responses:
'200':
content:
application/json:
schema:
items:
$ref: '#/components/schemas/Table'
title: Response Db Table Upstreams Api V1 Explore Db Data Connection Id Tables Table Path Upstreams Get
type: array
description: Successful Response
'422':
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
description: Validation Error
summary: Get table upstreams
tags:
- Explore
components:
schemas:
HTTPValidationError:
properties:
detail:
items:
$ref: '#/components/schemas/ValidationError'
title: Detail
type: array
title: HTTPValidationError
type: object
TableReference:
description: Database table reference.
properties:
name:
title: Table name
type: string
path:
items:
type: string
title: Table path
type: array
required:
- name
- path
title: TableReference
type: object
ColumnReference:
description: Database table column reference.
properties:
name:
title: Column name
type: string
required:
- name
title: ColumnReference
type: object
ValidationError:
properties:
loc:
items:
anyOf:
- type: string
- type: integer
title: Location
type: array
msg:
title: Message
type: string
type:
title: Error Type
type: string
required:
- loc
- msg
- type
title: ValidationError
type: object
Column:
description: Database table column.
properties:
name:
title: Name
type: string
table:
$ref: '#/components/schemas/TableReference'
type:
const: Column
default: Column
title: Type
type: string
required:
- name
- table
title: Column
type: object
Table:
description: Database table.
properties:
columns:
items:
$ref: '#/components/schemas/ColumnReference'
title: Columns
type: array
name:
title: Name
type: string
path:
items:
type: string
title: Table path
type: array
type:
const: Table
default: Table
title: Type
type: string
required:
- name
- columns
- path
title: Table
type: object
securitySchemes:
ApiKeyAuth:
description: Use the 'Authorization' header with the format 'Key <api-key>'
in: header
name: Authorization
type: apiKey