Feature request for CTE expansion in lineage view

[kevineh]

Describe the feature

Often in times when debugging large dbt models with many CTEs, we need to check results from certain CTEs to see if it produces expected results. It would be helpful if the lineage view the CTEs can be expanded into nodes and results from CTEs displayed along with the nodes.

Describe alternatives you've considered

What I currently do is to compile the model and change the select statement to the CTE that I want to check and run the query.

There's another tool, https://count.co/, out there does this gracefully as below. Since this comes as a part of the package and we can't switch to it just because of this one feature, we'd like to have it in dbt power usesr which we already use.

Who will benefit?

All dbt users. Debugging large models have always been a challenge to all dbt users and this new feature can be very helpful.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[mdesmet]

Thanks for raising this. This seems very useful.