Creating a zero-copy clone
Before running a bulk transformation on Snowy Peak's subscription data, the data team wants an instant backup. Snowflake's zero-copy clone creates an exact copy of a table in milliseconds — no storage duplication until the two tables diverge.
The snowy_peak.subscriptions table has columns subscription_id, user_email, plan, status, start_date, and monthly_fee.
This exercise is part of the course
Snowflake Architecture
Exercise instructions
- Create a zero-copy clone of
snowy_peak.subscriptionsnamedsnowy_peak.subscriptions_backupusingCREATE OR REPLACE TABLE ... CLONE ....
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create a zero-copy clone as a safety net
CREATE OR REPLACE TABLE snowy_peak.___
CLONE ___;