Overview Version History Q & A Rating & Review
Column Lineage — VS Code Extension
Interactive column-level data lineage visualization directly inside VS Code.
Features
🔍 Column-level lineage — trace data flow from source to destination, column by column📊 Interactive ERD diagram — clickable cards, search, pan/zoom, upstream/downstream tracing🐍 Python-aware — extracts embedded SQL from ETL scripts, Airflow DAGs, and more🏷️ PK/FK detection — automatic from DDL, dbt YAML tests, or naming heuristics⚡ One-click analysis — Cmd+Shift+L or right-click any folder🔄 Auto-refresh — optionally re-analyze on file save🌐 16 SQL dialects — BigQuery, Snowflake, Spark, DuckDB, Postgres, and more
Quick Start
Prerequisites
Usage
Open a workspace containing SQL/Python files
Press Cmd+Shift+L (or Ctrl+Shift+L on Windows/Linux)
The lineage diagram opens in a side panel
Click any column to trace its full lineage
Commands
Command
Shortcut
Description
Analyze Workspace Cmd+Shift+LScan the full workspace and show lineage
Analyze Current File Editor title bar icon
Scan adjacent files and show lineage
Open Visualization Status bar click
Reopen the lineage panel
Refresh Visualization —
Re-run analysis and update the panel
Settings
Setting
Default
Description
columnLineage.pythonPathpython3Python interpreter path
columnLineage.dialect(auto)
SQL dialect: bigquery, snowflake, spark, etc.
columnLineage.outputDir.lineageOutput folder for lineage files
columnLineage.includePythontrueExtract SQL from Python files
columnLineage.autoAnalyzeOnSavefalseRe-analyze on .sql/.py file save
columnLineage.analysisTimeout120Max seconds for analysis
Supported File Types
File Type
What it extracts
.sqlSELECT, CREATE TABLE AS SELECT, INSERT INTO SELECT
.yaml / .ymldbt schema files — columns, PK/FK from tests
.pySQL strings embedded in Python code
Requirements
VS Code 1.80+
Python 3.8+ with column-lineage-tool installed (pip install column-lineage-tool)
License
MIT
