Schema

Lineage

Code

SQL Visualizer

Beta

Runs

Opportunities

ALL_CUSTOMERS

SORTED_CUSTOMERS

CROSS_JOIN

CUSTOMER_WITH_CORRELATED_STATS

STRING_HEAVY_CUSTOMERS

WINDOW_HEAVY_CUSTOMERS

INNER_JOIN

UNUSED_CTE_1

LEFT_JOIN

ALL_ORDERS

SORTED_ORDERS

FILTER

INNER_JOIN

UNUSED_CTE_3

GROUP

ALL_PAYMENTS

SORTED_PAYMENTS

CROSS_JOIN

FILTER

UNUSED_CTE_2

GROUP

LEFT_JOIN

CUSTOMERS_SCAN_2

CUSTOMERS_SCAN_3

ORDERS_SCAN_2

ORDERS_SCAN_3

PAYMENTS_SCAN_2

CROSS_JOIN

CUSTOMER_ORDER_CROSS

DISTINCT_CUSTOMER_ORDERS

CUSTOMER_PAYMENT_CROSS

DISTINCT_CUSTOMER_PAYMENTS

TRIPLE_CROSS

DISTINCT_TRIPLE

FILTERED_BY_FUNCTIONS

LEFT_JOIN

UNION

PAYMENT_METHOD_COUNTS

UNION

ORDER_STATUS_COUNTS

UNION

CUSTOMER_SELF_JOIN

ORDER_SELF_JOIN

REDUNDANT_ORDER_STATS

LEFT_JOIN

REDUNDANT_PAYMENT_STATS

LEFT_JOIN

MEGA_JOIN

GROUP

FINAL

table

__final_select__

Press enter or space to select a node.You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.

Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.

⚠️ EXTREMELY INEFFICIENT MODEL - FOR OPTIMIZATION DEMONSTRATION ONLY ⚠️

This model showcases 20+ anti-patterns that will result in:

- High query costs

- Slow execution times

- Excessive resource consumption

- Memory spillage

ANTI-PATTERNS INCLUDED:

1. SELECT * everywhere

2. Multiple CROSS JOINs

3. Nested DISTINCT operations

4. Correlated subqueries (N+1 pattern)

5. Same table scanned 5+ times

6. Non-sargable WHERE clauses

7. Excessive window functions

8. Heavy string manipulations

9. UNION ALL instead of single query

10. ORDER BY in subqueries

11. Unused CTEs (dead code)

12. Deep query nesting

13. Cartesian products

14. Redundant aggregations

15. Multiple hash operations

16. Regular expressions

17. Type conversions

18. Date calculations in filters

19. Self-joins

20. Final ORDER BY on table

*/ /*

============================================================================ */ /

* LAYER 1: Base CTEs with SELECT * anti-pattern */ /*

============================================================================ */

WITH all_customers AS (

SELECT

FROM anas.dbt_cli_prd.stg_customers

), all_orders AS (

SELECT

FROM anas.dbt_cli_prd.stg_orders