Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

The correct answer is A. Pipe. Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches…

Data Loading and Unloading

Question

Options

APipe
BExternal stage
CTask
DStream

How the community answered

(19 responses)

A
79% (15)
B
5% (1)
C
11% (2)
D
5% (1)

Explanation

Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Topics

#Snowpipe#auto-ingest#continuous loading

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice