henryupton

Interrogate the Snowflake query plan for a dbt model in this repo (especially the incremental_scd2 MERGE) to check CTE reuse, join strategy, partition pruning, and window/sort counts. Use when judging query efficiency, verifying an optimization actually changed the plan, deciding whether a SQL rewrite is worthwhile, or whenever you need to run EXPLAIN against Snowflake through dbt-fusion.