Tuning the Snowflake Data Cloud: Optimizing Your Data Platform to Minimize Cost and Maximize Performance

by Andrew Carruthers

Overview

This project-oriented book presents a hands-on approach to identifying migration and performance issues with experience drawn from real-world examples. As you work through the book, you will develop skills, knowledge, and deep understanding of Snowflake tuning options and capabilities while preparing for later incorporation of additional Snowflake features as they become available. Your Snowflake platform will cost less to run and will improve your customer experience. Written by a seasoned Snowflake practitioner, this book is full of practical, hands-on guidance and advice specifically designed to further accelerate your Snowflake journey.

Tuning the Snowflake Data Cloud provides you a pathway to success by equipping you with the skills, knowledge, and expertise needed to elevate your Snowflake experience. The book shows you how to leverage what you already know, adds what you don’t, and helps you apply it toward delivering for your Snowflake accounts. Read this book to embark on a voyage of advancement and equip your organization to deliver consistent Snowflake performance.

What You Will Learn

• Recognize and understand the root cause of performance bottlenecks
• Know how to resolve performance issues
• Develop a deep understanding of Snowflake performance tuning options
• Reduce expensive mistakes, remediate poorly performing code
• Manage Snowflake costs

Product Details

ISBN-13:	9798868803789
Publisher:	Apress
Publication date:	05/29/2024
Edition description:	1st ed.
Pages:	425
Product dimensions:	7.01(w) x 10.00(h) x (d)

About the Author

Andrew Carruthers is the Director for Snowflake Distribution at the London Sk Exchange Group (LSEG). Andrew’s new role is to deliver several Snowflake accounts supporting Refinitiv “final mile” data product content delivery via Snowflake Marketplace, Private Listings and Data Shares.

Previously responsible for the Snowflake Corporate Data Cloud, Andrew was responsible for both ingestion data lake and consumption analytics hub, the Corporate Data Cloud services a growing customer base of over 7,000 end users. He also leads both the Centre for Enablement developing tooling, best practice and training, also the Snowflake Landing Zone provisioning Snowflake Accounts conforming to both internal standards and best practice.

Andrew has almost 30 years hands-on Relational Database design, development and implementation experience starting out with Oracle in 1993. Until joining LSEG, Andrew operated as an independent IT consultant, his experience has been gained through predominantly working at major European financial institutions. Andrew is considered a visionary and thought leader within his domain with tight focus on delivery. Successfully bridging the gap between Snowflake technological capability and business usage of technology, Andrew often develops proof of concepts to showcase benefits leading to successful business outcomes.

Since 2020 Andrew has immersed himself in Snowflake and is considered a Subject Matter Expert, he is CorePro certified, contributes to online forums and speaking at Snowflake events on behalf of LSEG. In recognition of his contribution to implementing Snowflake at LSEG, Andrew received the Snowflake Data Driver award, this category recognizes a technology trailblazer who has pioneered the Data Cloud into their organization.

Andrew has two daughters, 20 and 22, both elite figure skaters. He has a passion for Jaguar cars having both designed and implemented modifications, and has published articles for both the Jaguar Enthusiast Magazine and Jaguar Drivers Club. Andrew enjoys 3D printing and has a mechanical engineering workshop with lathe, milling machine, TIG welder to name but a few tools, and enjoys developing his workshop skills.

Table of Contents

1. Tuning the Snowflake Data Cloud.- 2. The Query Optimizer.- 3. The Query Profiler.- 4. Micro-Partitions.- 5. Cluster Keys.- 6. Warehouses.- 7. Search Optimization Service.- 8. Parallelization.- 9. Client Expectations.- 10. Optimizing Performance.- Appendix.