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

Carruthers, Andrew

  • 出版商: Apress
  • 出版日期: 2024-05-29
  • 售價: $2,330
  • 貴賓價: 9.5$2,214
  • 語言: 英文
  • 頁數: 425
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 9798868803789
  • ISBN-13: 9798868803789
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

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

商品描述(中文翻譯)

這本以專案為導向的書籍提供了一種實作的方法,幫助讀者識別遷移和性能問題,並以真實案例的經驗為基礎。在閱讀本書的過程中,您將培養技能、知識,並深入了解 Snowflake 的調整選項和功能,同時為未來整合更多 Snowflake 功能做好準備。您的 Snowflake 平台將降低運行成本,並改善客戶體驗。本書由一位經驗豐富的 Snowflake 實踐者撰寫,充滿了實用的、動手操作的指導和建議,專門設計用來進一步加速您的 Snowflake 之旅。

《Tuning the Snowflake Data Cloud》為您提供成功的途徑,讓您具備提升 Snowflake 體驗所需的技能、知識和專業知識。本書教您如何利用已有的知識,補充您所缺乏的部分,並幫助您將其應用於為您的 Snowflake 帳戶提供服務。閱讀本書,展開進步的旅程,並使您的組織能夠提供穩定的 Snowflake 性能。

您將學到的內容:
- 辨識並理解性能瓶頸的根本原因
- 知道如何解決性能問題
- 深入了解 Snowflake 性能調整選項
- 減少昂貴的錯誤,修正表現不佳的程式碼
- 管理 Snowflake 成本

作者簡介

Andrew Carruthers is the Director for Snowflake Distribution at the London Stock 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.

作者簡介(中文翻譯)

安德魯·卡魯瑟斯(Andrew Carruthers)是倫敦證券交易所集團(LSEG)Snowflake Distribution 的總監。安德魯的新角色是負責交付多個 Snowflake 帳戶,支持 Refinitiv 的「最後一公里」數據產品內容通過 Snowflake Marketplace、私人上市和數據共享進行交付。

在此之前,安德魯負責 Snowflake Corporate Data Cloud,管理數據湖的攝取和消費分析中心,Corporate Data Cloud 服務於超過 7,000 名終端用戶的日益增長的客戶群。他還領導了啟用中心,開發工具、最佳實踐和培訓,同時負責 Snowflake Landing Zone,提供符合內部標準和最佳實踐的 Snowflake 帳戶。

安德魯擁有近 30 年的關聯數據庫設計、開發和實施的實務經驗,自 1993 年開始與 Oracle 合作。在加入 LSEG 之前,安德魯作為獨立 IT 顧問,主要在歐洲主要金融機構工作,積累了豐富的經驗。安德魯被認為是其領域的願景者和思想領袖,專注於交付。他成功地架起了 Snowflake 技術能力與商業技術使用之間的橋樑,經常開發概念驗證以展示其好處,從而導致成功的商業成果。

自 2020 年以來,安德魯全心投入 Snowflake,並被視為主題專家,他擁有 CorePro 認證,並在 LSEG 代表 Snowflake 參加線上論壇和活動。因其在 LSEG 實施 Snowflake 的貢獻,安德魯獲得了 Snowflake Data Driver 獎,該類別表彰在其組織中開創數據雲的技術先驅。

安德魯有兩個女兒,分別為 20 和 22 歲,都是精英花式滑冰選手。他對捷豹汽車充滿熱情,曾設計和實施改裝,並為《Jaguar Enthusiast Magazine》和《Jaguar Drivers Club》發表過文章。安德魯喜愛 3D 打印,擁有一個機械工程工作坊,裡面有車床、銑床、TIG 焊接機等工具,並享受提升自己的工作坊技能。