Performance and Semantics

A warehouse fails its users in two ways: slow queries, or two dashboards giving different numbers for one question. This section treats each on BookNest's PostgreSQL 1,289 mart, then defines shared metrics once, with dbt 37,942 .

Subsections

• Slow Query Checklist
• Pre-Aggregation and Caching
• Why Dashboards Disagree
• dbt Semantic Layer and Cube
• A Shared Metric Set