Dwh.dev documentation
  • What is Dwh.dev?
  • Features
    • Data catalog
      • PIPEs
      • Fancy SQL Highlight
    • Data Lineage
      • Object-level lineage
      • Column-level Lineage
      • In-query lineage
      • Navigation
      • JOIN and WHERE
      • Equals column lineage
      • Strong and Weak dependencies
      • Default and Virtual Columns
      • Implicit Types casting
      • Circle dependencies
      • Argument forwarding
    • TASKs
  • Integrations
    • Snowflake
      • Offline mode
      • Secured online mode
      • Snowflake Marketplace
    • DBT
    • ETL
    • BI
      • Looker
      • Other
    • API
  • Snowflake SQL Syntax and Behavior
    • Identifiers
    • Reusing column aliases
    • SELECT * ILIKE EXCLUDE REPLACE RENAME
    • Scalar functions name resolution special behavior
    • Functions overloading
    • CTE as an expression alias
    • ASOF Join
    • UDF named arguments
    • Objects auto renaming
    • Columns auto renaming
Powered by GitBook
On this page

Was this helpful?

  1. Features
  2. Data Lineage

In-query lineage

PreviousColumn-level LineageNextNavigation

Last updated 8 months ago

Was this helpful?

we realized that no matter how accurately we display column-level lineage between objects, on the "last mile" (within CTAS/VIEW queries), SQL developers are left without help and spend a lot of time exploring complex queries.

We couldn't let this happen, so we developed a new

Now you can go deeper into a selected object's logic and get column-level lineage for the internals of a SELECT query with a unique feature - IN-QUERY LINEAGE.

In-query lineage

In the current "preview" stage, we highlight CTEs, sub-queries, pivots, joins, and unions. We allow collapsing/expanding each sub-query to control the level of detail.

This functionality is also available for DBT projects.