What is Snowflake - Visual Explanation

Process Flow - What is Snowflake

User wants to store data

↓

User uploads data to Snowflake

↓

Snowflake stores data in cloud storage

↓

User runs queries on data

↓

Snowflake processes queries using compute resources

↓

Results returned to user

Snowflake lets users upload data to the cloud, stores it safely, and runs queries quickly using separate compute power.

Execution Sample

Snowflake

CREATE TABLE users (id INT, name STRING);
INSERT INTO users VALUES (1, 'Alice');
SELECT * FROM users;

Creates a table, adds one user, then retrieves all users.

Process Table

Step	Action	Evaluation	Result
1	Create table 'users'	Table does not exist	Table 'users' created with columns id and name
2	Insert row (1, 'Alice')	Table 'users' exists	Row added to 'users'
3	Select all from 'users'	Table 'users' has 1 row	Returns [(1, 'Alice')]
4	End of commands	No more commands	Execution stops

💡 All commands executed successfully

Status Tracker

Variable	Start	After Step 1	After Step 2	After Step 3
users table	does not exist	exists empty	exists with 1 row	exists with 1 row

Key Moments - 2 Insights

Why does Snowflake separate storage and compute?

Snowflake stores data separately from compute so queries can run fast without affecting storage. See execution_table steps 3 and 4 where query runs independently.

Is data stored inside Snowflake or outside?

Data is stored in cloud storage outside Snowflake's compute layer, but Snowflake manages it. This is shown in the concept_flow step where data is uploaded and stored in cloud storage.

Visual Quiz - 3 Questions

Look at the execution_table, what is the result after step 2?

A Returns [(1, 'Alice')]

B Table 'users' created with columns id and name

C Row added to 'users'

D Execution stops

💡 Hint

Check the 'Result' column for step 2 in execution_table

At which step does Snowflake return query results?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at the 'Action' and 'Result' columns in execution_table

If we add more rows before step 3, how does it affect the result at step 3?

A Query will fail because table is too big

B More rows will be returned in the query result

C No change, only one row is returned

D Table will be deleted

💡 Hint

Refer to variable_tracker showing table rows after insertions

Concept Snapshot

Snowflake is a cloud data platform.
It separates storage and compute for speed and scalability.
Users upload data to cloud storage.
Compute resources run queries independently.
This allows fast, flexible data analysis.

Full Transcript

Snowflake is a cloud-based data platform that stores data separately from compute resources. Users upload data, which Snowflake stores in cloud storage. When users run queries, Snowflake uses compute resources to process them without affecting storage. This separation allows fast and scalable data handling. For example, creating a table, inserting data, and querying it shows how Snowflake manages data and compute independently.