Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling. By default a quick start: checks the dbt CLI, draws one business area as an ERD Studio logical model that mirrors dbt, checks it with the ERD Studio diff until logical matches physical and opens…
Audit SQL for the cost & performance anti-patterns that burn warehouse credits. Catches SELECT , full-table scans, non-sargable predicates, Cartesian joins, NULL-trap NOT IN, and 17 more rules. Scores warehouse health 0-100 and outputs a prioritized cost-reduction plan for BigQuery, Snowflake, Redshift, and Postgres.