Lineage

The dependencies between resources. Learn more about lineage here.

List Lineage

get

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/manual/

Get lineage objects with optional filtering by source and destination entity.

Authorizations

ApiKeyAuth

Query parameters

from_entitystring · nullableOptional

from_entity_idstring · nullableOptional

from_entity__instring · nullableOptional

to_entitystring · nullableOptional

to_entity_idstring · nullableOptional

to_entity__instring · nullableOptional

integration_typestring · nullableOptional

integration__typestring · nullableOptional

pageintegerOptionalDefault: 1

Responses

200

OK

application/json

countintegerRequired

total_pagesintegerRequired

get/api/v1/lineage/manual/

HTTPcURLJavaScriptPython

GET /api/v1/lineage/manual/ HTTP/1.1
Host: api.secoda.co
Accept: */*

200

OK

{
  "links": {
    "next": "text",
    "previous": "text"
  },
  "meta": {
    "page": 1,
    "previous_page": 1,
    "next_page": 1,
    "count": 1,
    "total_pages": 1
  },
  "count": 1,
  "total_pages": 1,
  "results": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "created_at": "2026-07-15T17:06:54.652Z",
      "updated_at": "2026-07-15T17:06:54.652Z",
      "from_entity_id": "123e4567-e89b-12d3-a456-426614174000",
      "to_entity_id": "123e4567-e89b-12d3-a456-426614174000",
      "direction": "text",
      "workspace_id": "123e4567-e89b-12d3-a456-426614174000",
      "is_manual": false
    }
  ]
}

Create new Lineage

post

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/manual/

Create a new lineage object manually. Only one direction of the relationship needs to be created. The opposite direction of the lineage is automatically generated.

Authorizations

ApiKeyAuth

Body

application/json

from_entitystringRequired

to_entitystringRequired

directionstring · enumOptionalPossible values:

Responses

200

OK

application/json

idstring · uuidOptional

created_atstring · date-timeRequired

updated_atstring · date-timeRequired

from_entity_idstring · uuidRequired

to_entity_idstring · uuidRequired

directionstring · nullableOptional

workspace_idstring · uuidRequired

is_manualbooleanOptionalDefault: false

201

Created

application/json

post/api/v1/lineage/manual/

HTTPcURLJavaScriptPython

POST /api/v1/lineage/manual/ HTTP/1.1
Host: api.secoda.co
Content-Type: application/json
Accept: */*
Content-Length: 66

{
  "from_entity": "text",
  "to_entity": "text",
  "direction": "DOWNSTREAM"
}

{
  "id": "123e4567-e89b-12d3-a456-426614174000",
  "created_at": "2026-07-15T17:06:54.652Z",
  "updated_at": "2026-07-15T17:06:54.652Z",
  "from_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "to_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "direction": "text",
  "workspace_id": "123e4567-e89b-12d3-a456-426614174000",
  "is_manual": false
}

Get Lineage

get

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/manual/{lineage_id}/

Get a lineage object by its ID.

Authorizations

ApiKeyAuth

Path parameters

lineage_idstringRequired

Responses

200

OK

application/json

idstring · uuidOptional

created_atstring · date-timeRequired

updated_atstring · date-timeRequired

from_entity_idstring · uuidRequired

to_entity_idstring · uuidRequired

directionstring · nullableOptional

workspace_idstring · uuidRequired

is_manualbooleanOptionalDefault: false

get/api/v1/lineage/manual/{lineage_id}/

HTTPcURLJavaScriptPython

GET /api/v1/lineage/manual/{lineage_id}/ HTTP/1.1
Host: api.secoda.co
Accept: */*

200

OK

{
  "id": "123e4567-e89b-12d3-a456-426614174000",
  "created_at": "2026-07-15T17:06:54.652Z",
  "updated_at": "2026-07-15T17:06:54.652Z",
  "from_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "to_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "direction": "text",
  "workspace_id": "123e4567-e89b-12d3-a456-426614174000",
  "is_manual": false
}

Delete Lineage

delete

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/manual/{lineage_id}/

Delete a lineage object by its ID.

Authorizations

ApiKeyAuth

Path parameters

lineage_idstringRequired

Responses

204

No Content

No content

delete/api/v1/lineage/manual/{lineage_id}/

HTTPcURLJavaScriptPython

DELETE /api/v1/lineage/manual/{lineage_id}/ HTTP/1.1
Host: api.secoda.co
Accept: */*

204

No Content

No content

Preview Lineage from Query

get

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/lineage_from_query/

Preview Lineage from a Query.

Authorizations

ApiKeyAuth

Query parameters

sqlstringRequired

The SQL query to analyze for lineage relationships

Example: SELECT a.customer_id, b.order_id FROM customers a JOIN orders b ON a.customer_id = b.customer_id

dialectstringRequired

SQL dialect of the query (e.g. postgresql, bigquery)

Example: postgresql

table_idstringOptional

ID of target table (optional)

Example: 550e8400-e29b-41d4-a716-446655440000

default_databasestringOptional

Default database name for resolving table references (optional)

Example: production

default_schemastringOptional

Default schema name for resolving table references (optional)

Example: public

Responses

200

OK

application/json

sqlstringRequired

get/api/v1/lineage/lineage_from_query/

HTTPcURLJavaScriptPython

GET /api/v1/lineage/lineage_from_query/?sql=SELECT+a.customer_id%2C+b.order_id+FROM+customers+a+JOIN+orders+b+ON+a.customer_id+%3D+b.customer_id&dialect=postgresql HTTP/1.1
Host: api.secoda.co
Accept: */*

200

OK

{
  "sql": "text",
  "source_tables": [
    {
      "id": "text",
      "created_at": "2026-07-15T17:06:54.652Z",
      "updated_at": "2026-07-15T17:06:54.652Z",
      "title": "text",
      "schema_name": "text",
      "database_name": "text",
      "native_type": "text",
      "integration_id": "text",
      "integration_title": "text",
      "integration_type": "text"
    }
  ],
  "column_lineages": [
    {
      "from_column": {
        "id": "text",
        "created_at": "2026-07-15T17:06:54.652Z",
        "updated_at": "2026-07-15T17:06:54.652Z",
        "title": "text",
        "entity_type": "text",
        "type": "text",
        "schema_name": "text",
        "database_name": "text",
        "native_type": "text",
        "integration_id": "text",
        "integration_title": "text",
        "integration_type": "text"
      },
      "to_column": {
        "id": "text",
        "created_at": "2026-07-15T17:06:54.652Z",
        "updated_at": "2026-07-15T17:06:54.652Z",
        "title": "text",
        "entity_type": "text",
        "type": "text",
        "schema_name": "text",
        "database_name": "text",
        "native_type": "text",
        "integration_id": "text",
        "integration_title": "text",
        "integration_type": "text"
      }
    }
  ],
  "target_table": {
    "id": "text",
    "created_at": "2026-07-15T17:06:54.652Z",
    "updated_at": "2026-07-15T17:06:54.652Z",
    "title": "text",
    "schema_name": "text",
    "database_name": "text",
    "native_type": "text",
    "integration_id": "text",
    "integration_title": "text",
    "integration_type": "text"
  }
}

Create Lineage from Query

post

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/lineage_from_query/

Create Lineage from a Query.

Authorizations

ApiKeyAuth

Body

application/json

sqlstringRequired

dialectstringRequired

table_idstring · nullableOptional

default_databasestring · nullableOptional

default_schemastring · nullableOptional

Responses

200

OK

No content

400

Bad Request

404

Provided table ID does not exist

500

Internal Server Error

post/api/v1/lineage/lineage_from_query/

HTTPcURLJavaScriptPython

POST /api/v1/lineage/lineage_from_query/ HTTP/1.1
Host: api.secoda.co
Content-Type: application/json
Accept: */*
Content-Length: 99

{
  "sql": "text",
  "dialect": "text",
  "table_id": "text",
  "default_database": "text",
  "default_schema": "text"
}

No content

Create Lineage from Query and Removes Existing Upstream Non-Manual Lineage from Target Table

patch

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/lineage_from_query/

Create Lineage from Query and Removes Existing Upstream Non-Manual Lineage from Target Table.

Authorizations

ApiKeyAuth

Body

application/json

sqlstringRequired

dialectstringRequired

table_idstring · nullableOptional

default_databasestring · nullableOptional

default_schemastring · nullableOptional

Responses

200

OK

No content

400

Bad Request

404

Provided table ID does not exist

500

Internal Server Error

patch/api/v1/lineage/lineage_from_query/

HTTPcURLJavaScriptPython

PATCH /api/v1/lineage/lineage_from_query/ HTTP/1.1
Host: api.secoda.co
Content-Type: application/json
Accept: */*
Content-Length: 99

{
  "sql": "text",
  "dialect": "text",
  "table_id": "text",
  "default_database": "text",
  "default_schema": "text"
}

No content

Create new Lineage

post

https://api.secoda.cohttps://eapi.secoda.cohttps://aapi.secoda.cohttps://customer_domain.secoda.co

/api/v1/lineage/

Create a new lineage object manually. Only one direction of the relationship needs to be created. The opposite direction of the lineage is automatically generated.

Authorizations

ApiKeyAuth

Body

application/json

from_entitystringRequired

to_entitystringRequired

directionstring · enumOptionalPossible values:

Responses

200

OK

application/json

idstring · uuidOptional

created_atstring · date-timeRequired

updated_atstring · date-timeRequired

from_entity_idstring · uuidRequired

to_entity_idstring · uuidRequired

directionstring · nullableOptional

workspace_idstring · uuidRequired

is_manualbooleanOptionalDefault: false

201

Created

application/json

post/api/v1/lineage/

HTTPcURLJavaScriptPython

POST /api/v1/lineage/ HTTP/1.1
Host: api.secoda.co
Content-Type: application/json
Accept: */*
Content-Length: 66

{
  "from_entity": "text",
  "to_entity": "text",
  "direction": "DOWNSTREAM"
}

{
  "id": "123e4567-e89b-12d3-a456-426614174000",
  "created_at": "2026-07-15T17:06:54.652Z",
  "updated_at": "2026-07-15T17:06:54.652Z",
  "from_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "to_entity_id": "123e4567-e89b-12d3-a456-426614174000",
  "direction": "text",
  "workspace_id": "123e4567-e89b-12d3-a456-426614174000",
  "is_manual": false
}