Arhitectura Snowflake
Emily Melhuish
Technical Curriculum Developer, Snowflake
Înainte
subscription are 847 de rânduriDELETE FROM subscriptions
WHERE status = 'inactive';

După
subscription are 0 rânduri
DATA_RETENTION_TIME_IN_DAYS poate fi setat la nivel de cont, bază de date, schemă sau tabelă (nivelul cel mai jos are prioritate)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;
Output
Table SUBSCRIPTIONS_BACKUP
successfully created.


Arhitectura Snowflake