Exercise

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.

Инструкции

100 XP

Create a zero-copy clone of snowy_peak.subscriptions named snowy_peak.subscriptions_backup using CREATE OR REPLACE TABLE ... CLONE ....

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Инструкции

Exercise