Arhitectura Snowflake
Emily Melhuish
Technical Curriculum Developer, Snowflake

COPY INTO pentru a le încărcaStage = locație de stocare temporară

Creare Stage intern
CREATE STAGE snowy_peak_stage;
Creare Stage extern
CREATE STAGE my_s3_stage
STORAGE_INTEGRATION = s3_int
URL = 's3://snowy-peak-data/raw/';
COPY INTO
INSERT
Interfața Snowsight

Interogare
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);
Încărcare
JSON se încarcă într-un tip special de coloană Snowflake numit VARIANT.
CREATE TABLE events (raw_event VARIANT);
COPY INTO events
FROM @snowy_peak_stage/events.json
FILE_FORMAT = (TYPE = JSON);
Interogare
Utilizați notația cu două puncte pentru a naviga structura JSON.
SELECT
raw_event:user_id::STRING AS user_id,
raw_event:event_type::STRING
AS event_type
FROM events;

Arhitectura Snowflake