dwh.dev lineage

dwh.dev is a Snowflake-native data lineage platform built on static code analysis, helping data teams visualize data flows and understand column-level dependencies without requiring direct warehouse connections.

Reviewed by 7wData

On this page

Publisher review

dwh.dev is a Snowflake-native data lineage platform built on static code analysis, helping data teams visualize data flows and understand column-level dependencies without requiring direct warehouse connections. The tool specializes in handling Snowflake-specific constructs—Dynamic Tables, Streams, Tasks, Pipes, and Policies—that generic lineage tools often miss. Founded in 2020 and based in Santa Monica, dwh.dev has positioned itself as a lightweight alternative to enterprise platforms like Alation or Collibra, with faster deployment and lower overhead.

The platform runs as a Snowflake native application inside your data warehouse or as a standalone cloud service analyzing SQL files offline, removing the need for read access to system catalogs. Column-level lineage visualization, in-query dependency drilling, and circular dependency detection are core features. The free tier supports up to 100 objects across one project, while the Pro tier ($3,000/month) scales to 5,000 objects.

Adoption is strongest among Snowflake shops with mature dbt workflows and teams needing deep column-level visibility quickly. The trade-off is focus: dwh.dev's strength is Snowflake lineage depth, not cross-warehouse catalog or governance features like Alation offers. Independent reviews are sparse, and the tool's relatively young market position means long-term vendor stability is a consideration for enterprises.

Get the AI & data signal, daily.

48k+ subscribers read this every morning. One email, both newsletters. Unsubscribe anytime.

How it works

  1. Static SQL analysis

    Parses DDL and DML statements into an internal representation to extract lineage without querying INFORMATION_SCHEMA, enabling offline analysis or restricted-access environments.

  2. Column-level lineage with JOIN/WHERE clause tracking

    Exposes hidden dependencies by analyzing join conditions and filtering logic, surfacing weaker dependencies missed by object-level-only tools.

  3. In-query lineage visualization

    Zoom into any SELECT statement to drill down into nested logic, CTEs, and subquery dependencies, then navigate upstream/downstream without context switching.

  4. Snowflake-native deployment

    Runs as a native application inside Snowflake using Snowflake-managed compute for all parsing and analysis, eliminating external dependencies and data egress.

  5. Offline mode for CI/CD and isolated environments

    Analyzes SQL static files without connecting to Snowflake, ideal for policy validation, pull-request checks, and air-gapped deployments.

  6. Snowflake object support

    Handles Dynamic Tables, Streams, Tasks, Pipes, Policies, and stage references—constructs that generic data lineage tools often skip or handle incompletely.

  7. Schema change tracking and alerts

    Monitors upstream and downstream impact of schema changes, cost of CTAS operations, and query history to contextualize lineage over time.

Strengths and trade-offs

Strengths

  • Fast deployment (minutes, not months) compared to Alation or Collibra, with minimal configuration overhead.
  • Deep support for Snowflake-specific objects (Streams, Tasks, Pipes) that enterprise tools handle only partially or not at all.
  • Offline mode allows lineage analysis without read access to system catalogs, enabling use in restricted or air-gapped environments.

Trade-offs

  • Narrow scope: Snowflake-only; no support for BigQuery, Redshift, Databricks, or cross-warehouse visibility.
  • No business glossary, naming conventions, or governance workflows; lineage visualization is the product, not a feature in a larger platform.
  • Limited independent reviews and young company (pre-seed stage); long-term vendor viability and roadmap transparency are open questions.

Pricing context

dwh.dev offers a freemium model with a free tier supporting up to 100 objects in one project, suitable for small teams or proof-of-concept use. The Pro tier costs $3,000/month for unlimited projects and 5,000 objects, placing it in the mid-market segment. Enterprise pricing is custom and unlocks unlimited capacity. Deployment via Snowflake Marketplace is available as a managed service, removing on-premise installation overhead.

Alternatives

User reviews

No user reviews yet. Be the first to write one.

Sources

Reporting on this tool draws on these publicly available sources.

  1. dwh.dev — Main product website; pricing tiers, deployment options, and company positioning.
  2. docs.dwh.dev — Official documentation covering all features, API, integrations with Snowflake, in-query lineage, and static analysis approach.
  3. www.cbinsights.com — Company founding year (2020), headquarters (Santa Monica, California), founders (Anton Revyako, Joao Correia), and funding stage.
  4. github.com — GitHub organization; open-source tooling and data-lineage-challenge reference implementation.
  5. www.alation.com — 2026 competitive context; dwh.dev not mentioned in this enterprise-focused comparison, confirming narrow market positioning vs. Alation, Collibra, Informatica.
  6. skyvia.com — 2026 data lineage tool landscape; confirms open-source and enterprise options but does not mention dwh.dev, highlighting its specialist rather than generalist positioning.