thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Snowpipe

Snowflake's serverless continuous ingestion service that loads staged files soon after arrival, triggered by cloud event notifications or REST calls.

Definition

A pipe wraps a COPY INTO statement. Auto-ingest uses S3 event notifications (SQS), Azure Event Grid or GCS Pub/Sub. Snowpipe keeps 14 days of load history to avoid duplicates, and compute is billed serverlessly.

Example

CREATE PIPE p AUTO_INGEST = TRUE AS COPY INTO raw.orders FROM @ext_stage;

Exam tip

Continuous micro-batch file loading = Snowpipe; scheduled large batch loads = COPY INTO on a warehouse.

Related terms