Why object hierarchy organizes data in Snowflake - See It in Action

Why object hierarchy organizes data

📖 Scenario: You are working with Snowflake, a cloud data platform. You want to understand how organizing data in an object hierarchy helps manage and access data efficiently.

🎯 Goal: Build a simple Snowflake database structure with a hierarchy of objects: a database, a schema inside it, and a table inside the schema. This will show how data is organized step-by-step.

📋 What You'll Learn

Create a database named CompanyDB

Create a schema named Sales inside CompanyDB

Create a table named Orders inside the Sales schema with columns OrderID (integer) and Amount (number)

Use the correct Snowflake SQL syntax for each step

💡 Why This Matters

🌍 Real World

Organizing data in a hierarchy is like organizing files in folders on your computer. It helps keep data tidy and easy to find.

💼 Career

Understanding Snowflake object hierarchy is essential for database administrators and data engineers managing cloud data platforms.

1

Create the database

Write a Snowflake SQL statement to create a database called CompanyDB.

Snowflake

-- Your code here

Need a hint?

Use the CREATE DATABASE command followed by the database name.

2

Create the schema inside the database

Write a Snowflake SQL statement to create a schema called Sales inside the database CompanyDB.

Snowflake

CREATE DATABASE CompanyDB;
-- Your code here

Need a hint?

Use CREATE SCHEMA with the full path DatabaseName.SchemaName.

3

Create the table inside the schema

Write a Snowflake SQL statement to create a table called Orders inside the schema Sales of database CompanyDB. The table should have columns OrderID as INTEGER and Amount as NUMBER.

Snowflake

CREATE DATABASE CompanyDB;
CREATE SCHEMA CompanyDB.Sales;
-- Your code here

Need a hint?

Use CREATE TABLE with the full path Database.Schema.Table and define columns with types.

4

Explain the hierarchy in a comment

Add a SQL comment explaining how the object hierarchy organizes data from database to schema to table.

Snowflake

CREATE DATABASE CompanyDB;
CREATE SCHEMA CompanyDB.Sales;
CREATE TABLE CompanyDB.Sales.Orders (OrderID INTEGER, Amount NUMBER);
-- Your comment here

Need a hint?

Write a comment starting with -- describing the hierarchy from database to schema to table.