Databases and schemas in Snowflake - Mini Project: Build & Apply

Databases and Schemas in Snowflake

📖 Scenario: You are working as a cloud data engineer. Your team needs a clear structure to organize data in Snowflake. This means creating a database and inside it, a schema to hold tables later.

🎯 Goal: Build a Snowflake setup by creating a database named company_data and inside it, a schema named sales_schema. This will prepare the environment for storing sales data.

📋 What You'll Learn

Create a database called company_data

Create a schema called sales_schema inside the company_data database

Use correct Snowflake SQL syntax

Follow best practices for naming and structure

💡 Why This Matters

🌍 Real World

Organizing data in Snowflake with databases and schemas helps teams keep data tidy and easy to find, just like folders on your computer.

💼 Career

Knowing how to create and manage databases and schemas is a basic skill for cloud data engineers and analysts working with Snowflake.

1

Create the company_data database

Write a Snowflake SQL command to create a database named company_data.

Snowflake

-- Your code here to create the database company_data

Need a hint?

Use the CREATE DATABASE command followed by the database name.

2

Create the sales_schema schema inside company_data

Write a Snowflake SQL command to create a schema named sales_schema inside the database company_data.

Snowflake

CREATE DATABASE company_data;
-- Your code here to create the schema sales_schema inside company_data

Need a hint?

Use CREATE SCHEMA with the full path including the database name.

3

Set the context to use company_data database

Write a Snowflake SQL command to set the current database context to company_data.

Snowflake

CREATE DATABASE company_data;
CREATE SCHEMA company_data.sales_schema;
-- Your code here to set the current database to company_data

Need a hint?

Use the USE DATABASE command to switch context.

4

Set the context to use sales_schema schema

Write a Snowflake SQL command to set the current schema context to sales_schema inside the company_data database.

Snowflake

CREATE DATABASE company_data;
CREATE SCHEMA company_data.sales_schema;
USE DATABASE company_data;
-- Your code here to set the current schema to sales_schema

Need a hint?

Use the USE SCHEMA command to switch schema context.