Maturing the Snowflake Data Cloud: A Templated Approach to Delivering and Governing Snowflake in Large Enterprises

This project-oriented book gives you a hands-on approach to designing, developing, and templating your Snowflake platform delivery. Written by seasoned Snowflake practitioners, the book is full of practical guidance and advice to accelerate and mature your Snowflake journey. Working through the examples helps you develop the skill, knowledge, and expertise to expand your organization's core Snowflake capability and prepare for later incorporation of additional Snowflake features as they become available. Your Snowflake platform will be resilient, fit for purpose, extensible, and guarantee rapid, consistent, and repeatable, pattern-based deployments ready for application delivery.
When a Snowflake account is delivered there are no controls, guard rails, external monitoring, nor governance mechanisms baked in. From a large organization perspective, this book explains how to deliver your core Snowflake platform in the form of a Landing Zone, a consistent, templated approach that assumes familiarity with Snowflake core concepts and principles. The book also covers Snowflake from a governance perspective and addresses the "who can see what?" question, satisfying requirements to know for certain that your Snowflake accounts properly adhere to your organization's data usage policies.
The book provides a proven pathway to success by equipping you with skill, knowledge, and expertise to accelerate Snowflake adoption within your organization. The patterns delivered within this book are used for production deployment, and are proven in real-world use. Examples in the book help you succeed in an environment in which governance policies, processes, and procedures oversee and control every aspect of your Snowflake platform development and delivery life cycle. Your environment may not be so exacting, but you'll still benefit from the rigorous and demanding perspective this book's authors bring to the table. The book shows you how to leverage what you already know and adds what you don't know, all applied to deliver your Snowflake accounts. You will know how to position your organization to deliver consistent Snowflake accounts that are prepared and ready for immediate application development.

What You Will Learn

• Create a common, consistent deployment framework for Snowflake in your organization
• Enable rapid up-skill and adoption of Snowflake, leveraging the benefits of cloud platforms
• Develop a deep understanding of Snowflake administration and configuration
• Implement consistent, approved design patterns that reduce account provisioning times
• Manage data consumption by monitoring and controlling access to datasets

Who This Book Is For
Systems administrators charged with delivering a common implementation pattern for all Snowflake accounts within an organization; senior managers looking to simplify the delivery of complex technology into their existing infrastructure; developers seeking to understand guard rails, monitoring, and controls to ensure that Snowflake meets their organization's requirements; sales executives needing to understand how their data usage can be monitored and gain insights into how their data is being consumed; governance colleagues wanting to know who can see each data set, and wanting to identify toxic role combinations, and have confidence that their Snowflake accounts are properly provisioned

這本以專案為導向的書籍將以實際操作的方式，幫助您設計、開發和建立Snowflake平台交付。由經驗豐富的Snowflake實踐者撰寫，本書充滿了實用的指導和建議，以加速和提升您的Snowflake之旅。通過實例的操作，您將發展技能、知識和專業能力，擴展組織的核心Snowflake能力，並為日後加入其他可用的Snowflake功能做好準備。您的Snowflake平台將具有彈性、適用於目的、可擴展，並保證快速、一致和可重複的基於模式的部署，以供應用交付使用。

當交付Snowflake帳戶時，並沒有內建控制、防護機制、外部監控或治理機制。從大型組織的角度來看，本書解釋了如何以登陸區（Landing Zone）的形式交付核心Snowflake平台，這是一種一致的、模板化的方法，假設讀者對Snowflake的核心概念和原則已經熟悉。本書還從治理的角度介紹了Snowflake，並回答了「誰可以看到什麼？」的問題，滿足確保Snowflake帳戶遵守組織數據使用政策的要求。

本書提供了一條成功的路徑，讓您具備在組織內加速採用Snowflake的技能、知識和專業能力。本書中提供的模式用於生產部署，並在實際使用中經過驗證。本書中的示例將幫助您在一個治理政策、流程和程序監督和控制Snowflake平台開發和交付生命週期的環境中取得成功。雖然您的環境可能沒有那麼嚴格，但您仍然可以從本書作者帶來的嚴謹和苛刻的觀點中受益。本書將向您展示如何利用您已經掌握的知識，並補充您所不知道的內容，以交付您的Snowflake帳戶。您將了解如何定位您的組織，以交付一致的Snowflake帳戶，並為即時應用開發做好準備。

您將學到什麼
- 在組織中為Snowflake創建一個共同、一致的部署框架
- 利用雲平台的優勢，實現快速的技能提升和Snowflake的採用
- 深入了解Snowflake的管理和配置
- 實施一致、經過批准的設計模式，減少帳戶配置時間
- 通過監控和控制對數據集的訪問，管理數據消耗

本書適合對象
- 負責在組織內為所有Snowflake帳戶提供共同實施模式的系統管理員
- 希望將複雜技術交付到現有基礎設施中的高級經理
- 希望了解防護機制、監控和控制以確保Snowflake滿足組織需求的開發人員
- 需要了解如何監控數據使用並獲得數據消耗洞察的銷售主管
- 希望知道誰可以看到每個數據集，並希望識別有害角色組合並確保Snowflake帳戶正確配置的治理同事

​Andrew Carruthers is the Director for the Snowflake Corporate Data Cloud at the London Stock Exchange Group. Comprising two Snowflake accounts supporting both ingestion data lake and consumption analytics hub, the Corporate Data Cloud services a growing customer base of over 7,000 end users. He leads both the Centre for Enablement in developing tooling, best practices, and training, and the Snowflake Landing Zone provisioning Snowflake Accounts conforming to both internal standards and best practices. This book is the distilled best practices for implementing a Snowflake Landing Zone.
Andrew has more than 30 years of hands-on relational database design, development, and implementation experience starting out with Oracle in 1993. Until joining the London Stock Exchange Group, he operated as an independent IT consultant. His experience has been gained predominantly through working at major European financial institutions. Andrew is considered a visionary and thought leader within his domain, with a tight focus on delivery. Successfully bridging the gap between Snowflake technological capability and business usage of technology, he often develops proof of concept to showcase benefits leading to successful business outcomes.
Since early 2020 Andrew has immersed himself in Snowflake and is considered a subject matter expert. He is SnowPro Core certified, contributes to online forums, and speaks at Snowflake events on behalf of the London Stock Exchange Group. In recognition of his contribution to implementing Snowflake at London Stock Exchange Group, Andrew recently 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, 19 and 21, 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 the Jaguar Driver magazine. Andrew enjoys 3D printing and has a mechanical engineering workshop with lathe, milling machine, and TIG welder, to name but a few tools, and enjoys developing his workshop skills.

Sahir Ahmed is a Snowflake CorePro certified developer working alongside Andrew on the Snowflake Corporate Data Cloud at the London Stock Exchange Group. Sahir began investing his time learning Snowflake prior to joining the London Stock Exchange Group. He drew upon his experience with other relational databases such as MySQL and MS Access. Sahir developed a passion for Snowflake by designing a car parts catalog using JavaScript stored procedures and SQL scripts. As Sahir's skills and knowledge expanded, he dug deeper into Snowflake and within a year he became SnowPro Core certified.
In his spare time, Sahir also takes advantage of his self-taught skills in both electrical and manual car repairs, working on many brands of cars such as Jaguar, BMW, and Audi, to name a few. He also competes in amateur boxing competitions. Seen as a role model, Sahir supports and encourages youngsters both within boxing and his wider community. His biggest driving factor, and where his most precious time, is his time spent with his wife and two young daughters. They keep his motivation alive and push him to be the best version of himself.

Andrew Carruthers是倫敦證券交易所集團(London Stock Exchange Group)的Snowflake Corporate Data Cloud主管。Corporate Data Cloud由兩個Snowflake帳戶組成，支援數據湖和分析中心，為超過7,000名終端用戶提供服務。他負責領導Enablement中心開發工具、最佳實踐和培訓，以及提供符合內部標準和最佳實踐的Snowflake帳戶的Snowflake Landing Zone。本書是實施Snowflake Landing Zone的精煉最佳實踐。

Andrew擁有超過30年的實踐關聯式數據庫設計、開發和實施經驗，從1993年開始就使用Oracle。在加入倫敦證券交易所集團之前，他是一名獨立的IT顧問。他的經驗主要來自於在歐洲主要金融機構的工作。Andrew被認為是他所在領域的有遠見和思想領袖，他專注於交付。他成功地彌合了Snowflake技術能力和業務對技術的使用之間的差距，他經常開發概念驗證來展示利益，從而實現成功的業務成果。

自2020年初以來，Andrew全身心投入到Snowflake中，被認為是一位專家。他是SnowPro Core認證人員，參與線上論壇，並代表倫敦證券交易所集團在Snowflake活動中發表演講。為了表彰他在倫敦證券交易所集團實施Snowflake的貢獻，Andrew最近獲得了Snowflake Data Driver獎。該獎項表彰了一位在其組織中開創了數據雲的技術先驅。

Andrew有兩個女兒，分別是19歲和21歲，都是精英花式滑冰選手。他對捷豹車有著濃厚的熱情，曾經設計並實施了一些改裝，並為《Jaguar Enthusiast》雜誌和《Jaguar Driver》雜誌發表文章。Andrew喜歡3D打印，並擁有一個機械工程車間，裡面有車床、銑床和TIG焊接機等工具，他喜歡發展自己的工作室技能。

Sahir Ahmed是倫敦證券交易所集團Snowflake Corporate Data Cloud的Snowflake CorePro認證開發人員，與Andrew一起工作。在加入倫敦證券交易所集團之前，Sahir花費了時間學習Snowflake。他利用自己在其他關聯式數據庫（如MySQL和MS Access）方面的經驗，對Snowflake產生了濃厚的興趣，並使用JavaScript存儲過程和SQL腳本設計了一個汽車零件目錄。隨著Sahir的技能和知識的擴展，他深入研究了Snowflake，在一年內獲得了SnowPro Core認證。

在業餘時間，Sahir還利用自學的電氣和手動汽車維修技能，修理各種品牌的汽車，如捷豹、寶馬和奧迪等。他還參加業餘拳擊比賽。作為一個榜樣，Sahir在拳擊和他所在社區中支持和鼓勵年輕人。他最重要的動力和最寶貴的時間是與妻子和兩個年幼女兒在一起。他們讓他保持動力，推動他成為最好的自己。