page279
367
Consider date ranges. Many data feeds contain date attributes, and some are suitable
for summarizing into an additional attribute containing YYYYMM only. By adding a new
month-based attribute, you will enable filtering by month, which may facilitate micro-
partition pruning.
Design for consumption. ingestion (usually) happens once, whereas consumption
happens many times for the same data set.
Benchmark CSP Performance
Most organizations have strategic platforms and commercial arrangements with one,
two, or all three CSPs. Where choice exists, perform benchmark testing to identify the
best-performing CSP for identical workloads. We are aware of performance differences
in comparable virtual environments across different CSPs.
While not broken down by CSP, Snowflake publishes a performance index showing
workload performance improvements over time for which further information can be
found at
https://www.snowflake.com/en/data-cloud/pricing/performance-index/
.
Query Performance
Identifying query performance can be performed using several out-of-the-box tools; we
highlight some available options next.
Figure 10-5 shows the Snowsight tools referenced in this section.
ChapTer 10
OpTimizing perfOrmanCe