Current Level 1: SNOWFLAKE Level-0
0 / 5 Miles
0 / 6 Assignments
0 / 5 Exams

📖 Course Miles: Passed Failed Pending Not Attempted

Mile 2: Introduction

🎬 YouTube Videos

No YouTube videos available

Check back later for new YouTube content.

📹 Library Videos

Introduction_video
Introduction to Snowflake

📚 Content

SECTION 1 WHAT IS SNOWFLAKE?

3 min read

Snowflake
Snowflake is a cloud-based data platform that allows organizations to store, manage, process and analyze large amounts of data. It provides a centralized platform where data can be accessed and analyzed without managing complex hardware or infrastructure.

Data Warehouse
A Data Warehouse is a centralized repository that collects and stores data from multiple sources in an organized manner. It is mainly used for reporting, data analysis, business intelligence and decision-making.

Cloud Computing
Cloud Computing is the delivery of computing services such as servers, storage, databases and software over the Internet. It allows users to access these resources without purchasing or maintaining physical hardware.


Key Points About Snowflake

  1. Snowflake is a cloud-based data platform.
  2. It is provided as a Software as a Service (SaaS).
  3. It does not require users to install or manage physical hardware.
  4. Infrastructure maintenance and management are handled by Snowflake.
  5. It supports structured and semi-structured data.
  6. It allows users to store and analyze data efficiently.

Key Features

  • Separation of Storage and Compute: Data storage and computing resources work independently.
  • Automatic Scaling: Computing resources can adjust according to workload requirements.
  • Secure Data Sharing: Data can be shared securely between Snowflake users.

Real-World Example
An online shopping company collects customer details, product information, orders and payment records. Snowflake can store and process this data in one centralized platform, helping the company analyze sales and customer behaviour.

Sign up or sign in to rate this section
SECTION 2 HISTORY

2 min read

  • 2012 – Foundation: Snowflake Inc. was founded in 2012 in San Mateo, California, by three data warehousing experts: Benoit Dageville, Thierry Cruanes and Marcin Zukowski.
  • Founders' Background: Benoit Dageville and Thierry Cruanes previously worked as data architects at Oracle Corporation, while Marcin Zukowski was a co-founder of Vectorwise.
  • Early Leadership: Mike Speiser of Sutter Hill Ventures served as Snowflake's first CEO. Bob Muglia was appointed CEO in June 2014.
  • October 2014 – Launch from Stealth Mode: Snowflake officially came out of stealth mode and introduced its cloud data warehouse platform to the market.
  • June 2015 – Product Launch: Snowflake launched its cloud data warehouse product, making cloud-based data warehousing more accessible to organizations.
  • 2020 – Public Listing: Snowflake became a publicly traded company on the New York Stock Exchange (NYSE) under the ticker symbol SNOW.

Key Takeaway
Snowflake started in 2012 with a vision to build a data warehouse specifically for the cloud. Over time, it evolved into a widely used cloud-based data platform.

Sign up or sign in to rate this section
SECTION 3 SUPPORTED CLOUD PLATFORMS

2 min read

Supported Cloud Platforms
Snowflake is a cloud-based data platform that runs on three major cloud service providers. Users can choose a cloud platform based on their organization's requirements.

1.  Amazon Web Services (AWS)
AWS is a cloud computing platform provided by Amazon. It offers services such as storage, computing, networking and databases.

2.  Microsoft Azure
Microsoft Azure is a cloud computing platform provided by Microsoft. It offers services for data storage, application development, computing and analytics.

3. Google Cloud Platform (GCP)
Google Cloud Platform is a cloud computing platform provided by Google. It offers services for data storage, computing, networking and data analytics.


Key Points

  • Snowflake supports AWS, Microsoft Azure and Google Cloud.
  • Organizations can choose a cloud platform based on their business needs.
  • Snowflake manages its storage, compute and cloud services layers on the selected platform.
  • Each Snowflake account is hosted on a selected cloud platform and region.

Real-World Example
If a company already uses AWS for its applications and data storage, it can choose to host its Snowflake account on AWS for easier integration.

Sign up or sign in to rate this section
SECTION 4 SNOWFLAKE EDITIONS

3 min read

Snowflake Editions
Snowflake offers different editions (tiers) to meet the security, performance and business requirements of organizations. Each edition provides the features of the previous edition along with additional capabilities.

1. Standard Edition
Standard Edition is the basic Snowflake offering. It provides essential features for data storage, processing, querying and analysis.

  • Suitable for small and medium-sized organizations.
  • Provides core data warehousing features.
  • Offers a balance between features and cost.

2. Enterprise Edition
Enterprise Edition includes all Standard Edition features along with additional capabilities for large-scale organizations.

  • Supports multi-cluster virtual warehouses.
  • Provides extended Time Travel (up to 90 days).
  • Supports advanced security features such as masking policies and row-level security.
  • Suitable for organizations with complex data requirements.

3. Business Critical Edition
Business Critical Edition includes all Enterprise Edition features with enhanced security and data protection for organizations handling highly sensitive data.

  • Supports sensitive data requiring regulatory compliance, such as HIPAA and HITRUST.
  • Provides enhanced security features.
  • Supports account failover and failback for business continuity and disaster recovery.
  • Suitable for healthcare, financial and other highly regulated industries.

4. Virtual Private Snowflake (VPS)
Virtual Private Snowflake provides the highest level of isolation and security offered by Snowflake.

  • Includes all Business Critical Edition features.
  • Runs in a completely separate Snowflake environment.
  • Does not share hardware resources with accounts outside the VPS environment.
  • Suitable for organizations with very strict security and isolation requirements, such as large financial institutions.
Sign up or sign in to rate this section

📝 Assignment

Available Assignments
Assignment Pass Mark Duration Actions
Journey 1 - Introduction
70% 01:00:00

📊 Exam

Available Exams
Exam Pass Mark Duration Questions Actions
Journey 1 - Introduction
70% 00:30:00 5

💬 Comments & Discussion

Sign up free or sign in to post a comment
Sign up free or sign in
No comments yet

Be the first to share your thoughts!