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

Which of the following can be executed/called with Snowpipe?
A . A User Defined Function (UDF)
B . A stored procedure
C . A single copy_into statement
D . A single insert__into statement

View Answer

Answer: C

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.

Reference: Snowpipe | Snowflake Documentation