Skip to main content
These endpoints expose column-level lineage, upstream and downstream traversal, impact analysis for proposed changes, schema-change simulation, and impact graph payloads for visualization tools.
Authenticate with Authorization: Bearer <api_key>. See Authentication.

​
Base URL

https://api.planasonix.com

​
Column-level lineage

GET /api/lineage/columns
Returns lineage edges for columns matching filters. Use this as the default entry point when you know table and column identifiers from the catalog. Query parameters (typical)
ParameterDescription
table_fqnFully qualified table name (for example warehouse.analytics.fct_orders)
column_nameColumn name within the table
depthMaximum hop depth (default 5, max 20)
include_inactiveInclude deprecated or archived edges
Response 200 OK 
{
  "data": {
    "root": {
      "table_fqn": "warehouse.analytics.fct_orders",
      "column_name": "order_total_usd"
    },
    "edges": [
      {
        "from": {
          "table_fqn": "warehouse.staging.stg_shopify_orders",
          "column_name": "total_price"
        },
        "to": {
          "table_fqn": "warehouse.analytics.fct_orders",
          "column_name": "order_total_usd"
        },
        "transform": "sql_expression",
        "pipeline_id": "pl_01hqxyz",
        "confidence": "high"
      }
    ],
    "generated_at": "2025-03-27T15:00:00Z"
  }
}

​
Trace upstream dependencies

GET /api/lineage/columns/upstream
Walks sources and intermediate models that feed the specified column. Query parameters
ParameterDescription
table_fqn, column_nameStarting column
depthHop limit
Response 200 OK 
{
  "data": {
    "start": {
      "table_fqn": "warehouse.analytics.fct_orders",
      "column_name": "order_total_usd"
    },
    "nodes": [
      {
        "table_fqn": "warehouse.analytics.fct_orders",
        "column_name": "order_total_usd",
        "depth": 0
      },
      {
        "table_fqn": "warehouse.staging.stg_shopify_orders",
        "column_name": "total_price",
        "depth": 1
      },
      {
        "table_fqn": "raw.shopify.orders",
        "column_name": "total_price",
        "depth": 2
      }
    ],
    "edges": [
      {
        "from": "raw.shopify.orders.total_price",
        "to": "warehouse.staging.stg_shopify_orders.total_price"
      },
      {
        "from": "warehouse.staging.stg_shopify_orders.total_price",
        "to": "warehouse.analytics.fct_orders.order_total_usd"
      }
    ]
  }
}

​
Trace downstream consumers

GET /api/lineage/columns/downstream
Lists dashboards, derived tables, and pipelines that depend on the column. Response 200 OK 
{
  "data": {
    "start": {
      "table_fqn": "warehouse.analytics.fct_orders",
      "column_name": "order_total_usd"
    },
    "nodes": [
      {
        "table_fqn": "warehouse.analytics.fct_orders",
        "column_name": "order_total_usd",
        "depth": 0,
        "kind": "table"
      },
      {
        "id": "dash_01jq8rev",
        "name": "Executive revenue",
        "kind": "looker_dashboard",
        "depth": 1
      },
      {
        "table_fqn": "warehouse.marts.rev_by_region",
        "column_name": "gross_revenue_usd",
        "depth": 1,
        "kind": "table"
      }
    ],
    "edges": [
      {
        "from": "warehouse.analytics.fct_orders.order_total_usd",
        "to": "warehouse.marts.rev_by_region.gross_revenue_usd"
      }
    ]
  }
}

​
Run impact analysis

GET /api/lineage/impact-analysis
Evaluates blast radius for a proposed table or column change (rename, type change, drop). Query parameters
ParameterDescription
table_fqnAffected table
column_nameOptional; omit for table-wide analysis
change_typerename, type_change, drop, add
Response 200 OK 
{
  "data": {
    "change": {
      "table_fqn": "warehouse.staging.stg_shopify_orders",
      "column_name": "total_price",
      "change_type": "type_change",
      "from_type": "NUMERIC(12,2)",
      "to_type": "NUMERIC(18,6)"
    },
    "summary": {
      "affected_downstream_nodes": 14,
      "affected_pipelines": 3,
      "risk_level": "medium"
    },
    "affected_assets": [
      {
        "kind": "pipeline",
        "id": "pl_01hqxyz",
        "name": "staging_to_analytics_orders"
      },
      {
        "kind": "table",
        "table_fqn": "warehouse.analytics.fct_orders",
        "impact": "column_expression_may_coerce"
      }
    ]
  }
}

​
Simulate a schema change

POST /api/lineage/simulate-change
Runs a dry-run prediction without mutating metadata. Useful in CI before merging DDL. Request body 
{
  "table_fqn": "warehouse.analytics.dim_customer",
  "change_type": "drop",
  "column_name": "legacy_segment",
  "options": {
    "assume_cascade": false,
    "include_bi_tools": true
  }
}
Response 200 OK 
{
  "data": {
    "simulation_id": "linsim_01jq801",
    "change": {
      "table_fqn": "warehouse.analytics.dim_customer",
      "column_name": "legacy_segment",
      "change_type": "drop"
    },
    "predicted_breakages": [
      {
        "severity": "high",
        "asset": {
          "kind": "pipeline",
          "id": "pl_01hqabc",
          "name": "customer_360_enrichment"
        },
        "reason": "SQL references dim_customer.legacy_segment"
      }
    ],
    "safe_to_apply": false,
    "computed_at": "2025-03-27T15:05:00Z"
  }
}

​
Impact graph visualization data

GET /api/lineage/impact-graph
Returns a graph suited for force-directed or hierarchical renders (nodes and links with stable IDs). Query parameters
ParameterDescription
root_table_fqnCenter the graph on this table
root_column_nameOptional column focus
directionboth, upstream, downstream
max_nodesCap for browser performance (default 500)
Response 200 OK 
{
  "data": {
    "nodes": [
      {
        "id": "tbl:warehouse.analytics.fct_orders",
        "label": "fct_orders",
        "type": "table",
        "tier": "gold"
      },
      {
        "id": "col:warehouse.analytics.fct_orders#order_total_usd",
        "label": "order_total_usd",
        "type": "column",
        "parent_table_id": "tbl:warehouse.analytics.fct_orders"
      },
      {
        "id": "dash:dash_01jq8rev",
        "label": "Executive revenue",
        "type": "dashboard"
      }
    ],
    "links": [
      {
        "source": "col:warehouse.staging.stg_shopify_orders#total_price",
        "target": "col:warehouse.analytics.fct_orders#order_total_usd",
        "kind": "lineage"
      },
      {
        "source": "col:warehouse.analytics.fct_orders#order_total_usd",
        "target": "dash:dash_01jq8rev",
        "kind": "consumption"
      }
    ],
    "layout_hints": {
      "suggested_root": "tbl:warehouse.analytics.fct_orders"
    }
  }
}

Lineage

How lineage is collected in Planasonix.

Impact analysis

Change management workflows in the UI.