Data Protection and Sharing

Snowflake Architecture

Emily Melhuish

Technical Curriculum Developer, Snowflake

When Something Goes Wrong

Before

DELETE FROM subscriptions
WHERE status = 'inactive';

After

Query data at any point in time in the retention window
DATA_RETENTION_TIME_IN_DAYS can be set at account, database, schema, or table (lowest level wins)
Standard: a one-day window is maximum data retention time
Enterprise: up to 90 days (per edition and object rules)
Not limited to SELECT queries

Timeline showing now and 90 days ago

AT TIMESTAMP
- Exact moment in time
AT OFFSET
- Number in seconds
- Negative means backwards
- -3600 = one hour ago

AT BEFORE(STATEMENT) / BEFORE(STATEMENT)
- Ties recovery using its query id
- You return to the state of the data before that statement
UNDROP
- For example, UNDROP TABLE t
- Only works while it is still recoverable

Automatically retains the data a further 7 days after time travel (Fail-safe)
Default, no enablement needed
Snowflake support required to recover
data in Fail-safe counts against your bill

Timeline showing options

SQL

CREATE TABLE SUBSCRIPTIONS_BACKUP 
  CLONE subscriptions;

Output

Table SUBSCRIPTIONS_BACKUP 
successfully created.

Show clone and zero sharing storage

Snowflake marketplace screenshot

Snowflake Architecture