Full Description
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
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.
