The Column View Lineage feature visually breaks down the entire view into manageable chunks - from sources to the final list of columns. Click on any intermediate step or component columns, and jump straight to the underlying code to reveal the details. Zoom, scroll, and navigate any view with the ease and agility of a SqlDBM diagram.

Note, this is currently available for Snowflake objects only. Further support is planned for the near future.

Currently supported objects include (Snowflake):

• Views

• Materialized Views

• Dynamic Tables

Using Column View Lineage

To use this feature, click on the Column View Lineage icon on SqlDBM's left-hand menu. Select an existing view to get started.

Alternatively, you can jump to the Column View Lineage screen by right-clicking on a view in Diagram Explorer, Database Explorer, or on a diagram.

Explore the source-to-target visualization on the top of the screen using the familiar navigation controls.

Click on any column in the top part of the screen to highlight that part of the code in the editor below.

Conversely, click on any line of code to see it highlighted from source to target in the visual diagram.

Edit and Refresh

Views can be modified from the editor at the bottom of the lineage screen. Make the necessary changes and press the "Visualize all Views" button to refresh and see them reflected in the visual diagram above.