Snowflake 架构
Emily Melhuish
Technical Curriculum Developer, Snowflake
之前
subscription 表有 847 行DELETE FROM subscriptions
WHERE status = 'inactive';

之后
subscription 表有 0 行
DATA_RETENTION_TIME_IN_DAYS 可在账户、数据库、架构或表级设置(就近级别生效)SELECT 查询
AT BEFORE(STATEMENT) / BEFORE(STATEMENT)
UNDROP
UNDROP TABLE tAT BEFORE(STATEMENT) / BEFORE(STATEMENT)
UNDROP
UNDROP TABLE t
SQL
CREATE TABLE SUBSCRIPTIONS_BACKUP
CLONE subscriptions;
输出
Table SUBSCRIPTIONS_BACKUP
successfully created.


Snowflake 架构