Which of the following can be executed/called with Snowpipe?

The correct answer is C. A single copy_into statement. Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements.

Data Loading and Unloading

Question

Options

AA User Defined Function (UDF)
BA stored procedure
CA single copy_into statement
DA single insert__into statement

How the community answered

(55 responses)

A
2% (1)
B
4% (2)
C
95% (52)

Explanation

Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements.

Topics

#Snowpipe#Continuous data loading#COPY INTO#Data ingestion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice