Skip to main content
SpringerLink
Log in
Apress

Snowflake Essentials

Getting Started with Big Data in the Cloud

  • Book
  • © 2022

Overview

Authors:
  1. Frank Bell

    1. Encino, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Raj Chirumamilla

    1. Monmouth Jct, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Bhaskar B. Joshi

    1. Bethesda, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  4. Bjorn Lindstrom

    1. Eatonville, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  5. Ruchi Soni

    1. New Delhi, India

    View author publications

    You can also search for this author in PubMed   Google Scholar

  6. Sameer Videkar

    1. Magdeburg, Germany

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Helps you build valuable skills in the market-leading database analytics platform and largest software IPO in history
  • Covers emerging features such as Snowflake Data Sharing, Data Exchanges, and the Snowflake Data Marketplace
  • Explains and shows how Snowflake’s unique architecture is different from other databases

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xviii
    Download chapter PDF

  2. The Snowflake Data Cloud

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 1-10

  3. Snowflake Quick Start

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 11-24

  4. Snowflake Data Cloud Architecture

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 25-37

  5. Snowflake Web Interface: Classic Console

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 39-73

  6. Snowflake Web Interface: Preview App (Snowsight)

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 75-113

  7. Account Management

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 115-137

  8. Security

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 139-174

  9. Database Objects

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 175-195

  10. Querying and Cloning Data in Snowflake

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 197-222

  11. How Snowflake Compute Works

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 223-237

  12. Semi-structured Data in Snowflake

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 239-251

  13. Loading Data

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 253-281

  14. Unloading Data

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 283-298

  15. Data Sharing, Data Exchanges, and the Snowflake Data Marketplace

    • Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar
    Pages 299-328

  16. Back Matter

    Pages 329-337
    Download chapter PDF
Back to top

Keywords

About this book

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 Learn
  • Run analytics in the Snowflake Data Cloud
  • Create users and roles in Snowflake
  • Set up security in Snowflake
  • Set up resource monitors in Snowflake
  • Set up and optimize Snowflake Compute
  • Load, unload, and query structured and unstructured data (JSON, XML) within Snowflake
  • Use Snowflake Data Sharing to share data
  • Set up a Snowflake Data Exchange
  • Use the Snowflake Data Marketplace






Who This Book Is For


Database 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

Authors and Affiliations

  • Encino, USA

    Frank Bell

  • Monmouth Jct, USA

    Raj Chirumamilla

  • Bethesda, USA

    Bhaskar B. Joshi

  • Eatonville, USA

    Bjorn Lindstrom

  • New Delhi, India

    Ruchi Soni

  • Magdeburg, Germany

    Sameer Videkar

About the authors

​Frank Bell is a SnowPro, entrepreneur, and data thought leader and 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 Cloud Products (ITS) and Snowflake Solutions which are focused on building Snowflake tools such as DQmation (data quality automation). He also leads the Accenture Snowflake West Market unit. He has lived, breathed, and eaten Snowflake since early 2018 and believes Snowflake and the data cloud are one of the top game-changing technologies of this decade.

Raj Chirumamilla is a Snowflake Certified Architect and AWS Solutions Architect Associate with 20+ years of IT experience. He is an experienced, hands-on solutions architect working in the data and analytics area: helping customers migrate to cloud and build cost-effective and highly available solutions and data pipelines with modern data architecture frameworks. He has been working with Snowflake's Cloud Data platform for more than three years. 



Bhaskar B. Joshi is a Snowflake Certified Architect with 20 years of experience in managing data on various platforms. He has been working with Snowflake for over three years in multiple industries. He is currently a hands-on Data Architect helping customers create scalable solutions using the Modern Data Architecture frameworks in the cloud. 




Bjorn Lindstrom is an IT veteran with 40 years of experience in many aspects of computer technologies. He has held roles in software development, software quality assurance, database administration, large-scale big data systems, and is an experienced solutions architect. He was one of the first to be certified in Snowflake.



Ruchi Soni is a technology leader and multi-cloud enterprise architect. Her work lies in helping customers to accelerate their digital transformation journey to the cloud and to build next-generation apps on forward-looking platforms such as Snowflake. She brings extensive experience in planning, architecting, building, and scaling future-ready platforms that are highly available and agile. Ruchi is SnowPro Core certified, Google Cloud certified, AWS certified, and is a Certified Master Data Architect.




Sameer Videkar is a data expert with more than 12 years of experience working on data platforms, enterprise data warehouse systems, master data management, data migration, and ETL implementations. He is a certified Data Architect with additional certifications in Snowflake, Agile Scrum, and PMP.




Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation