| Category | SQL |
|---|
| Warehouse | CREATE WAREHOUSE wh WAREHOUSE_SIZE = 'XSMALL' AUTO_SUSPEND = 300; |
| Database | CREATE DATABASE db;
CREATE DATABASE db2 CLONE db; |
| Schema | CREATE SCHEMA db.schema; |
| Table | CREATE TABLE t (id INT, name STRING); |
| Stage | CREATE STAGE s;
PUT file://data.csv @s; |
| Load | COPY INTO t FROM @s FILE_FORMAT=(TYPE=CSV); |
| Unload | COPY INTO @s/out/ FROM t;
GET @s/out/ file://local/; |
| External | CREATE STAGE s3 URL='s3://bucket/' STORAGE_INTEGRATION=i; |
| Time Travel | SELECT * FROM t AT(TIMESTAMP=>...); |
| Clone | CREATE TABLE t2 CLONE t; |