Maturing the Snowflake Data Cloud

A Templated Approach to Delivering and Governing Snowflake in Large Enterprises

Andrew Carruthers, Sahir Ahmed

• Publisher: Apress
• Year: 2023
• Print ISBN: 9781484293393
• eBook ISBN: 9781484293409
• Topic: Computer Science
• Subtopic: Business Intelligence
• Index: Computer Science

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 showsyou 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 implementationpattern 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

Table of contents

• Cover
• Front Matter
• 1. Maturing the Snowflake Data Cloud
• 2. Implementing PrivateLink
• 3. Security Monitoring
• 4. Cost Reporting
• 5. Share Utilization
• 6. Usage Reporting
• 7. Data Catalog
• 8. Organization
• 9. Alerting
• 10. Cloud Data Management Capabilities (CDMC)
• 11. Behavior Change Management
• 12. Disaster Recovery
• Back Matter