page21
1
© Andrew Carruthers 2024
A. Carruthers, Tuning the Snowflake Data Cloud, https://doi.org/10.1007/979-8-8688-0379-6_1
CHAPTER 1
Tuning the Snowflake
Data Cloud
This book continues from where both Building the Snowflake Data Cloud (Apress, 2022)
and Maturing the Snowflake Data Cloud (Apress, 2023) left off. In this new volume, I
deep dive into tuning Snowflake queries to deliver blisteringly fast performance along
with a concurrent focus on cost-reduction efforts.
I unpack the core principles of how to approach performance optimization from
several perspectives.
•
Developers migrating existing applications to Snowflake must
understand the pitfalls and “gotchas” that await the unwary.
•
Cost management in an on-demand environment is a perpetual
challenge, and squeezing every drop of performance from Snowflake
is imperative.
•
Optimizing warehouse size can reduce costs and improve
throughput but often treats the symptoms and not the root cause of
performance issues.
•
Reducing micro-partition churn also reduces both storage and
replication costs with the further benefit of reducing propagated data
set latency, and I show you how.
•
Remediating performance issues and refactoring production code to
optimize performance involves trade-offs; there are no silver bullets!
•
Updating existing Snowflake implementations to take advantage of
new techniques is dependent upon understanding emerging product
capabilities.