page318
406
parallelize some operations specifically for large table scans and ad hoc analytics. Mixed
workloads may also benefit from query acceleration.
Before enabling query acceleration, test the existing configuration by decreasing the
warehouse size and/or number of clusters to reduce the number of available processing
units and then enable query acceleration. Look for queueing under the normal system
load conditions.
Query acceleration incurs compute cost only; no additional storage costs accrue.
Refer to Chapter 6 for a detailed investigation of query acceleration.
Resource Monitors
Snowflake provides resource monitors as a means to control warehouse consumption,
which is a reactive approach to limiting costs once the specified threshold has been
reached.
Serverless Compute
Snowflake features increasingly offer serverless compute for cost-effective and simple
implementation, but costs can quickly escalate.
The following table illustrates serverless compute components along with a brief
summary of capabilities provisioned as derived from
https://docs.snowflake.com/en/
user-guide/cost-understanding-compute#serverless-credit-usage
.
Component
Feature
Compute
automatic
Clustering
automated background maintenance of each clustered table,
including initial clustering and reclustering as needed
Serverless only
external Tables
automated refreshing of the external table metadata with the
latest set of associated files in the external stage and path
Serverless only
materialized Views
automated background synchronization of each materialized
view with changes in the base table for the view
Serverless only
Query acceleration
Service
execution of portions of eligible queries
Serverless only
(continued)
ChapTer 10
OpTimizing perfOrmanCe