Advertisement

© 2020

Jumpstart Snowflake

A Step-by-Step Guide to Modern Cloud Analytics

Book

Table of contents

  1. Front Matter
    Pages i-xiii
  2. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 1-17
  3. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 19-34
  4. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 35-51
  5. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 53-68
  6. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 69-87
  7. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 89-105
  8. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 107-128
  9. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 129-145
  10. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 147-175
  11. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 177-193
  12. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 195-211
  13. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 213-228
  14. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 229-249
  15. Dmitry Anoshin, Dmitry Shirokov, Donna Strok
    Pages 251-259
  16. Back Matter
    Pages 261-267

About this book

Introduction

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.

You will:

  • 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


Keywords

Snowflake Cloud Analytics Big Data Solutions Data Warehouse Spark Data Warehouse modernization ETL ELT Business Intelligence

Authors and affiliations

  1. 1.British ColumbiaCanada
  2. 2.BurnabyCanada
  3. 3.SeattleUSA

About the authors

Dmitry Anoshin is a data-centric technologist and recognized expert in building and implementing business/digital intelligence solutions. He has a successful track record of implementing analytics projects in numerous industries: retail, finance, marketing, and eCommerce. He possesses an in-depth knowledge of BI, ETL, DWH, and big data technologies and is experienced in data integration processes and proficient use of various data warehousing methodologies. He completed and met deadlines for a number of multinational full BI solution life cycle implementation projects.

Dmitry Shirokov is a Data Architect & Cloud Analytics Consultant at Rock Your Data, focused on digital transformation, design analytics solutions, data integration and migration, data governance, and cloud/in-house infrastructure. With over 10 years of experience in data analytics and big data, he has the breadth and depth of experience needed to build mature analytical solutions. Before joining Rock Your Data in early 2018, he worked in different companies in tech consulting and banking sectors. Previously, he held various data-engineering positions focusing on data-driven business transformation.

Donna Strok loves all things data and for over 10 years has worked in the field with companies such as Expedia Group, JPMorgan Chase and most recently Amazon. She earned her Bachelors degree in Computer Science and her Masters in Computer Information Systems.

She resides in beautiful Seattle, WA with her cat Dwayne Johnson and in her free time enjoys the wanderlust of world travel. She’s always on the on the hunt for exploring unique grocery stores and amazing hole-in the-wall restaurants, where some of her most memorable meals have been had.


Bibliographic information

Industry Sectors
Pharma
Automotive
Chemical Manufacturing
Biotechnology
IT & Software
Telecommunications
Consumer Packaged Goods
Aerospace
Engineering
Finance, Business & Banking
Electronics