Clone use cases (dev, testing, backups) in Snowflake - Mini Project: Build & Apply

Clone use cases (dev, testing, backups)

📖 Scenario: You work at a company that uses Snowflake for data storage. Your team wants to create copies of a database for different purposes like development, testing, and backups without using extra storage space.

🎯 Goal: Build Snowflake commands step-by-step to create a database clone, configure it for testing, and set up a backup clone.

📋 What You'll Learn

Create a database named sales_db with sample data

Create a clone of sales_db named sales_db_dev for development

Create a clone of sales_db named sales_db_test for testing

Create a clone of sales_db named sales_db_backup for backup

💡 Why This Matters

🌍 Real World

Cloning databases in Snowflake is useful for creating isolated environments for development, testing, and backups without duplicating data storage.

💼 Career

Many cloud data engineers and analysts use cloning to manage data environments efficiently and reduce costs.

1

Create the original database sales_db

Write a Snowflake SQL command to create a database called sales_db.

Snowflake

-- Your code here

Need a hint?

Use the CREATE DATABASE statement followed by the database name.

2

Create a development clone sales_db_dev

Write a Snowflake SQL command to create a clone of the sales_db database named sales_db_dev for development use.

Snowflake

CREATE DATABASE sales_db;
-- Your code here

Need a hint?

Use CREATE DATABASE <new_name> CLONE <source_name> to create a clone.

3

Create a testing clone sales_db_test

Write a Snowflake SQL command to create a clone of the sales_db database named sales_db_test for testing purposes.

Snowflake

CREATE DATABASE sales_db;
CREATE DATABASE sales_db_dev CLONE sales_db;
-- Your code here

Need a hint?

Clone the original database again with a new name for testing.

4

Create a backup clone sales_db_backup

Write a Snowflake SQL command to create a clone of the sales_db database named sales_db_backup to serve as a backup.

Snowflake

CREATE DATABASE sales_db;
CREATE DATABASE sales_db_dev CLONE sales_db;
CREATE DATABASE sales_db_test CLONE sales_db;
-- Your code here

Need a hint?

Create one more clone for backup purposes using the same syntax.