What’s new: dbt Model Lineage Support on IDE

Introducing dbt™️model Lineage support directly accessible for your dbt™️repositories in the IDE!

‍

Lineage offers a comprehensive and logical view of how data models in your dbt repositories are interconnected and how data flows through them, facilitating effective dbt model management. As you navigate through dbt™️ models, the lineage panel dynamically updates to display the most current dependencies. When you edit and commit changes, the lineage automatically refreshes to reflect the new structure.

‍

Key benefits

Alerts help you track and manage notifications externally in the following ways:

‍

1. Explore table-level lineage between upstream and downstream dbt™️ models using a DAG (Directed Acyclic Graph) playground, where models are represented as nodes and dependencies as edges.Before making upstream changes to your sources or models, assess their immediate dependencies (+2/-2) to minimize downstream impact.
2. Minimize downstream impact: Before making upstream changes to your sources or models, assess their immediate dependencies (+2/-2) to minimize downstream impact.
3. Trace model and dashboard issues: Quickly trace and resolve model and BI dashboard issues by pinpointing the exact source, ensuring transparency and integrity in your data modeling process.‍
4. Prevent accidental downstream issues: Review the model’s lineage before committing changes to prevent unintended downstream effects, safeguarding your Jobs and BI applications.

‍

Key features

The following features are supported:

‍

1. Advanced complex search functionality (+2/-2) to view immediate nodes (parent & child) for both upstream and downstream dependencies of a model. 
2. The interactive model highlights to check the model’s path from source to downstream applications. 
3. Download the model lineage graph in SVG for better scalability and accessibility. 
4. Customizable DAG playground with drag-and-drop functionality.
5. Accessibility functions to zoom in/out, sync and reset the view.

‍

Accessibility

The feature is available to 5X  Admins and Developers.

You can view the Lineage of your dbt model from:

‍

1. IDE > Files > Github to open the dbt console. 
2. Open the dbt model file from your GitHub repository to open the dbt Console. Click the Lineage tab from the Results panel.

Check out Docs to learn more.