Jumpstart Snowflake: A Step-by-Step Guide to Modern Cloud Analytics

✍ Scribed by Dmitry Anoshin, Dmitry Shirokov, Donna Strok

• Publisher: Apress
• Year: 2020
• Tongue: English
• Leaves: 270
• Edition: 1st ed.
• Category: Library

✦ Synopsis

Explore the modern market of data analytics platforms and the benefits of using Snowflake computing, the data warehouse built for the cloud.

With the rise of cloud technologies, organizations prefer to deploy their analytics using cloud providers such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Cloud vendors are offering modern data platforms for building cloud analytics solutions to collect data and consolidate into single storage solutions that provide insights for business users. The core of any analytics framework is the data warehouse, and previously customers did not have many choices of platform to use.

Snowflake was built specifically for the cloud and it is a true game changer for the analytics market. This book will help onboard you to Snowflake, present best practices to deploy, and use the Snowflake data warehouse. In addition, it covers modern analytics architecture and use cases. It provides use cases of integration with leading analytics software such as Matillion ETL, Tableau, and Databricks. Finally, it covers migration scenarios for on-premise legacy data warehouses.

What You Will Learn

• Know the key functionalities of Snowflake
  
• Set up security and access with cluster
  
• Bulk load data into Snowflake using the COPY command
  
• Migrate from a legacy data warehouse to Snowflake
  
• integrate the Snowflake data platform with modern business intelligence (BI) and data integration tools

Who This Book Is For

Those working with data warehouse and business intelligence (BI) technologies, and existing and potential Snowflake users

✦ Table of Contents

Front Matter ....Pages i-xiii
Getting Started with Cloud Analytics (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 1-17
Getting Started with Snowflake (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 19-34
Building a Virtual Warehouse (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 35-51
Loading Bulk Data into Snowflake (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 53-68
Getting Started with SnowSQL (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 69-87
Continuous Data Loading with Snowpipe (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 89-105
Snowflake Administration (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 107-128
Snowflake Security Overview (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 129-145
Working with Semistructured Data (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 147-175
Secure Data Sharing (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 177-193
Designing a Modern Analytics Solution with Snowflake (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 195-211
Snowflake and Data Science (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 213-228
Migrating to Snowflake (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 229-249
Time Travel (Dmitry Anoshin, Dmitry Shirokov, Donna Strok)....Pages 251-259
Back Matter ....Pages 261-267

✦ Subjects

Computer Science; Computer Applications