Snowflake 架构
Emily Melhuish
Technical Curriculum Developer, Snowflake

COPY INTO 加载Stage = 临时存储位置

创建内部 Stage
CREATE STAGE snowy_peak_stage;
创建外部 Stage
CREATE STAGE my_s3_stage
STORAGE_INTEGRATION = s3_int
URL = 's3://snowy-peak-data/raw/';
COPY INTO
INSERT
Snowsight UI

查询
CREATE OR REPLACE FILE FORMAT csv_format
TYPE = CSV
SKIP_HEADER = 1;
COPY INTO orders
FROM @snowy_peak_stage/orders.csv
FILE_FORMAT = (FORMAT_NAME = csv_format);
加载
JSON 会加载到 Snowflake 的特殊列类型 VARIANT 中。
CREATE TABLE events (raw_event VARIANT);
COPY INTO events
FROM @snowy_peak_stage/events.json
FILE_FORMAT = (TYPE = JSON);
查询
使用冒号表示法遍历 JSON 结构。
SELECT
raw_event:user_id::STRING AS user_id,
raw_event:event_type::STRING
AS event_type
FROM events;

Snowflake 架构