Ruchi Soni - Böcker

Understand the essentials of the Snowflake Database and the overall Snowflake Data Cloud. This book covers how Snowflake’s architecture is different from prior on-premises and cloud databases. The authors also discuss, from an insider perspective, how Snowflake grew so fast to become the largest software IPO of all time.Snowflake was the first database made specifically to be optimized with a cloud architecture. This book helps you get started using Snowflake by first understanding its architecture and what separates it from other database platforms you may have used. You will learn about setting up users and accounts, and then creating database objects. You will know how to load data into Snowflake and query and analyze that data, including unstructured data such as data in XML and JSON formats. You will also learn about Snowflake’s compute platform and the different data sharing options that are available. What YouWill LearnRun analytics in the Snowflake Data CloudCreate users and roles in SnowflakeSet up security in SnowflakeSet up resource monitors in SnowflakeSet up and optimize Snowflake ComputeLoad, unload, and query structured and unstructured data (JSON, XML) within SnowflakeUse Snowflake Data Sharing to share dataSet up a Snowflake Data ExchangeUse the Snowflake Data MarketplaceWho This Book Is ForDatabase professionals or information technology professionals who want to move beyond traditional database technologies by learning Snowflake, a new and massively scalable cloud-based database solution

Master the intricacies of Snowflake and prepare for the SnowPro Advanced Architect Certification exam with this comprehensive study companion. This book provides robust and effective study tools to help you prepare for the exam and is also designed for those who are interested in learning the advanced features of Snowflake. The practical examples and in-depth background on theory in this book help you unleash the power of Snowflake in building a high-performance system. The best practices demonstrated in the book help you use Snowflake more powerfully and effectively as a data warehousing and analytics platform.Reading this book and reviewing the concepts will help you gain the knowledge you need to take the exam. The book guides you through a study of the different domains covered on the exam: Accounts and Security, Snowflake Architecture, Data Engineering, and Performance Optimization. You’ll also be well positioned to apply your newly acquired practical skills to real-world Snowflake solutions. You will have a deep understanding of Snowflake to help you take full advantage of Snowflake’s architecture to deliver value analytics insight to your business.What You Will LearnGain the knowledge you need to prepare for the examReview in-depth theory on Snowflake to help you build high-performance systemsBroaden your skills as a data warehouse designer to cover the Snowflake ecosystemOptimize performance and costs associated with your use of the Snowflake data platformShare data securely both inside your organization and with external partnersApply your practical skills to real-world Snowflake solutionsWho This Book Is ForAnyone who is planning to take the SnowPro Advanced Architect Certification exam, those who want to move beyond traditional database technologies and build their skills to design and architect solutions using Snowflake services, and veteran database professionals seeking an on-the-job reference to understand one of the newest and fastest-growing technologies in data