Scribd
Upload
4 views27 pages

Snowflake: A Columnar Database Overview

Snowflake is a cloud data warehouse solution that utilizes columnar data storage for efficient data retrieval and analysis. It features a unique architecture that decouples storage and compute, enhancing scalability and performance while supporting various data types. Snowflake is designed for large-scale data sets and offers multi-cloud support, making it a competitive choice in the data warehousing market.

Uploaded by

timothyzheng2000
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views27 pages

Snowflake: A Columnar Database Overview

Snowflake is a cloud data warehouse solution that utilizes columnar data storage for efficient data retrieval and analysis. It features a unique architecture that decouples storage and compute, enhancing scalability and performance while supporting various data types. Snowflake is designed for large-scale data sets and offers multi-cloud support, making it a competitive choice in the data warehousing market.

Uploaded by

timothyzheng2000
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

What is Snowflake?

INTRODUCTION TO SNOWFLAKE

Palak Raina
Senior Data Engineer
What is Snowflake?
Cloud data warehouse solution
Columnar data storage

INTRODUCTION TO SNOWFLAKE
Cloud data warehouse

Traditional data warehouse Cloud data warehouse

INTRODUCTION TO SNOWFLAKE
Advantages of Cloud data warehouses

INTRODUCTION TO SNOWFLAKE
Row vs. Columnar database

INTRODUCTION TO SNOWFLAKE
Row vs. Columnar database

Category Row Columnar


Data By Rows By Columns
Organization
Data
Complete records Relevant columns
Retrieval
Operations Transactional Analytical

Example Postgres, MySQL, Oracle, Snowflake, Amazon Redshift, Google


Microsoft SQL Server BigQuery, Vertica

INTRODUCTION TO SNOWFLAKE
Snowflake

INTRODUCTION TO SNOWFLAKE
Snowflake use cases

INTRODUCTION TO SNOWFLAKE
Let's practice!
INTRODUCTION TO SNOWFLAKE
Snowflake
Architecture
INTRODUCTION TO SNOWFLAKE

Palak Raina
Senior Data Engineer
Shared-Disk and Shared-Nothing Architecture

INTRODUCTION TO SNOWFLAKE
Decoupling Storage & Compute

Efficient data storage.

Independent data processing.


Components operate without interdependence.

Benefits

Enhanced scalability.

Faster data processing and response.


Cost-effective operations.

INTRODUCTION TO SNOWFLAKE
Snowflake Architecture

INTRODUCTION TO SNOWFLAKE
Storage Layer
Columnar storage
Efficient data retrieval

Analysis

Optimized

Compressed

Tables, schemas, databases

INTRODUCTION TO SNOWFLAKE
Compute Layer
Query execution
Virtual warehouses

INTRODUCTION TO SNOWFLAKE
Compute Layer - virtual warehouse

Scalability

Performance
Cost-effectiveness

Different sizes: XS, S, M, L, XL

INTRODUCTION TO SNOWFLAKE
Cloud Services Layer
Infrastructure management
Query Optimization

Authentication

Access control

Security

INTRODUCTION TO SNOWFLAKE
Let's practice!
INTRODUCTION TO SNOWFLAKE
Snowflake
Competitors and
why use Snowflake
INTRODUCTION TO SNOWFLAKE

Palak Raina
Senior Data Engineer
Snowflake Competitors

INTRODUCTION TO SNOWFLAKE
Comparison: Architecture, Scalability & Management

INTRODUCTION TO SNOWFLAKE
Security & Data Support
Security Semi-Structured Data Support

Access Controls JSON

Encryption Avro
Parquet

CSV
Unstructured Data Support - Databricks

Text, images, and audio

INTRODUCTION TO SNOWFLAKE
Integration & Pricing

INTRODUCTION TO SNOWFLAKE
What makes Snowflake Unique?

Unique architecture - decoupling compute, storage

Secure data sharing

High performance

Multi-Cloud Support

Pricing

INTRODUCTION TO SNOWFLAKE
Why use Snowflake?

Large-scale data sets

Multi-Cloud Support
Pricing

Ease of use

INTRODUCTION TO SNOWFLAKE
SnowflakeSQL vs. PostgreSQL
American National Standards Institute(ANSI) SQL
Example:

select * from orders

INTRODUCTION TO SNOWFLAKE
Let's practice!
INTRODUCTION TO SNOWFLAKE

You might also like