Dbt Language Server Protocol Lsp Integration For Column Level Lineage

via “dbt test result aggregation and impact lineage tracking”

Open-source dbt-native data observability and anomaly detection.

Unique: Parses dbt's native artifacts (manifest.json, run_results.json) to build lineage without requiring additional instrumentation or API calls to dbt Cloud. Stores lineage in the warehouse itself (Elementary's metadata schema) rather than external graph databases, enabling SQL-based impact queries.

vs others: More lightweight than dbt Cloud's native lineage (no SaaS dependency) and more dbt-specific than generic data lineage tools like OpenMetadata, which require custom connectors. Integrates test results directly into lineage, unlike dbt Cloud which separates test results from DAG visualization.

via “column-level lineage tracking and visualization”

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.

Unique: Column-level lineage extraction from SQL, dbt, and Spark with automatic DAG construction and interactive visualization, rather than table-level lineage only; integrates lineage extraction into the ingestion pipeline itself

vs others: Deeper than Collibra's table-level lineage because it tracks individual column transformations; more automated than manual lineage tools because it parses transformation logic directly

via “dbt language server protocol (lsp) integration for column-level lineage”

** - Official MCP server for [dbt (data build tool)](https://www.getdbt.com/product/what-is-dbt) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Unique: Integrates with dbt Fusion LSP to provide column-level lineage analysis that goes beyond model-level dependencies, enabling fine-grained impact analysis and data flow tracing. Uses LSP protocol for standardized code intelligence features.

vs others: More precise than model-level lineage because it traces individual columns through transformations, and more interactive than static analysis because it leverages LSP for real-time code intelligence.

via “column-level lineage and data type tracking”

** - MCP server for dbt-core (OSS) users as the official dbt MCP only supports dbt Cloud. Supports project metadata, model and column-level lineage and dbt documentation.

Unique: Extracts column-level lineage from dbt manifest contracts and test metadata, enabling fine-grained tracking of data transformations. Combines column definitions, test associations, and data type information into unified lineage graph without requiring SQL parsing.

vs others: Provides column-level detail that simple model lineage cannot offer, and requires no external data catalog or SQL parsing — all information comes from dbt artifacts.

via “automated lineage documentation and dependency mapping”

Unique: Operates on dbt's native manifest and DAG structure rather than reverse-engineering lineage from SQL parsing alone, enabling accurate dependency tracking that respects dbt's ref(), source(), and macro semantics.

vs others: More accurate than generic data lineage tools because it leverages dbt's explicit dependency declarations rather than inferring relationships from SQL text analysis, reducing false positives and false negatives.

via “dbt-transformation-monitoring”