page319
407
Component
Feature
Compute
replication
automated copying of data between accounts, including
initial replication and maintenance as needed
Serverless only
Search
Optimization
Service
automated background maintenance of the search access
paths used by the search optimization service
Serverless only
Snowpipe
automated processing of file loading requests for each pipe
object
Serverless or
warehouse
Snowpipe
Streaming
automated processing of file loading requests for each pipe
object; currently
INSERT
only
Serverless only
Tasks
Scheduled tasks
Serverless or
warehouse
Testing Code Changes
Most of the performance tuning advice provided in this chapter involves making invasive
code changes. A recurring theme is to test once, test twice, and then test again. Make
no apology for insisting upon full testing using production-like workloads. Executive
management requires low-risk, high-value delivery, and your testing must reflect best
practices at all times.
Summary
This chapter began by considering design decisions that have the most decisive impact
on system performance. Tuning the design is the most important advice available
before attempting to write any code and applies ubiquitously to all platforms, not just
Snowflake.
The chapter next identified the available tools to aid your investigations and
provided template code (several earlier chapters have deep dives and full explanations
for the identified tooling).
ChapTer 10
OpTimizing perfOrmanCe