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.
Este ejercicio forma parte del curso
Snowflake Architecture
Instrucciones del ejercicio
- Create a zero-copy clone of
snowy_peak.subscriptionsnamedsnowy_peak.subscriptions_backupusingCREATE OR REPLACE TABLE ... CLONE ....
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
-- Create a zero-copy clone as a safety net
CREATE OR REPLACE TABLE snowy_peak.___
CLONE ___;