Frank Bell , Raj Chirumamilla , Bhaskar B. Joshi , Bjorn Lindstrom , Ruchi Soni and Sameer Videkar
Snowflake Essentials
Getting Started with Big Data in the Cloud
Logo of the publisher
Raj Chirumamilla
Monmouth Jct, USA
Bhaskar B. Joshi
Bethesda, MD, USA
Bjorn Lindstrom
Eatonville, USA
Ruchi Soni
New Delhi, Delhi, India
Sameer Videkar
Magdeburg, Sachsen-Anhalt, Germany
ISBN 978-1-4842-7315-9 e-ISBN 978-1-4842-7316-6
https://doi.org/10.1007/978-1-4842-7316-6
Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar 2022
This work is subject to copyright. All rights are solely and exclusively licensed by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use.
The publisher, the authors and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
This Apress imprint is published by the registered company APress Media, LLC part of Springer Nature.
The registered company address is: 1 New York Plaza, New York, NY 10004, U.S.A.
Foreword
In 2010, Marc Andreessen wrote an op-ed in The Wall Street Journal titled Why Software Is Eating the World as many brick-and-mortar businesses were being disrupted by digitally native firms like Amazon, Uber, and Apple. The pace of disruption has accelerated further as organizations have embraced a data-driven approach to transforming businesses. Data has become central to transforming how companies interface with their customers, suppliers, and partners, find new ways to generate revenues, create new ecosystems, and improve operational efficiencies.
Data is now used in innovating almost every aspect of life, such as new drug research, autonomous vehicles, smart cities, adjusting insurance claims, creating art and music and the list goes on. Data has become so pervasive that the best way to describe this new world is that Data is feeding the world. The recent COVID pandemic has also necessitated that companies move their apps and data estates to the cloud. The combined data and cloud trend has given rise to a new breed of data platforms that enable enterprise initiatives to become data-driven. One such popular data platform is Snowflake a platform that has taken the industry by storm since its unprecedented IPO in September 2020.
This is a timely book on the Snowflake data platform that covers the essentials as well as some expert topics such as data architectures. Frank, Bjorn, Raj Chirumamilla, Sameer Videkar, Bhaskar Joshi, and Ruchi Soni are top experts in Snowflake and have packed this book with stellar content on Snowflake and how to use it effectively.
The authors have become deep Snowflake experts and have been working extensively on Snowflake for many years. They have helped build Snowflake consulting solutions that have helped numerous Snowflake implementations and clients. Frank, in particular, has been immersed in Snowflake since the beginning of 2018. He transformed his previous big data consulting business to become one of the key Snowflake implementation partners before being acquired by Accenture.
This book will help data professionals learn all the essentials around the Snowflake Data Cloud. It also covers some of the transformative Snowflake architecture and features in depth such as data sharing. My favorite chapter in the book is Chapter on data sharing, exchanges, and marketplaces. It provides an insightful look at how data sharing is transforming the evolution of data collaboration to digitally transform businesses.
Shail Jain
Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484273159. For more detailed information, please visit http://www.apress.com/source-code.
Table of Contents
COPY into Command
Loading Data via SnowSQL
Download SnowSQL
Install SnowSQL
Log In and Set Context
List Files from Internal Stage
Stage Files with the PUT Command
Load Data with the COPY Command
Verify the Results
Summary
Chapter 13: Unloading Data
Sample Dataset
Setting Up the Context
Log In to Your Snowflake Account
Create a Stage
COPY INTO and GET Commands
COPY INTO Command
GET Command
Unloading Data
From a Table
From a SQL Statement
Download Data via SnowSQL
Log In and Set Context
List Files from Internal Stage
Download Files with the GET Command
Summary
Chapter 14: Data Sharing, Data Exchanges, and the Snowflake Data Marketplace
Data Sharing History
What Is Data Sharing?
Data Copies Everywhere
The BI Tool Extract Effect and Data Governance and Integrity Impacts
Data Sharing on the Snowflake Data Cloud
Snowflake Data Sharing History
The Business Value and Power of Instantaneous Data Sharing
Data Sharing Market Adoption
How Data Sharing Works on Snowflake
How to Create Data Shares and Access Data Shares on Snowflake
How to List Snowflake Data Shares Shared Data
How to Create a Snowflake Data Share
How to Create Reader Accounts
Setting Up a Data Share with Code
Data Exchanges
Creating Your Own Private Data Exchange Steps
The Snowflake Data Marketplace
The Growth of the Snowflake Data Marketplace from June 2020 to June 2021
How to Use the Snowflake Data Marketplace as a Consumer
Summary
Index
About the Authors
Frank Bell
is a SnowPro, Snowflake Data Hero, entrepreneur, and data thought leader who has been working with databases since 1994 when he first started with Oracle in the United States Air Force. He ran the consulting firm IT Strategists from 1999 to 2019 and built one of the fastest-growing Snowflake practices in 2018, which was sold to Fairway Technologies and then acquired by Accenture. He now runs IT Strategists (ITS) Cloud Products (