COF-C03 practice question 8 of 10

True or False: Snowpipe via REST API can only reference External Stages as source.

Full set: 1,126 questions
Answer options
A: True
B: False Correct answer
Correct Answer:
B. False
Explanation

The statement is false. Snowpipe, including when invoked via its REST API, can load data from both internal (Snowflake-managed) stages and external stages (e.g., Amazon S3, Google Cloud Storage, Microsoft Azure). The CREATE PIPE command allows the definition of a pipe that copies data from either an internal or an external stage. The REST API is simply a mechanism to notify Snowpipe to process specific files located in the stage defined in the pipe's definition, regardless of the stage type.

Why Incorrect

A. (True) This is incorrect because Snowpipe is designed to work with both internal and external stages, providing flexibility for various data ingestion architectures.

References

1. Snowflake Documentation. (n.d.). REST API for Snowpipe. Retrieved from https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest. The documentation describes the insertFiles endpoint, which triggers a pipe to load files from its defined stage, without restricting the stage type.

2. Snowflake Documentation. (n.d.). CREATE PIPE. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/create-pipe. The syntax and examples clearly show pipes being created on both internal (@~, @%) and external (@myextstage) stages.

Scroll to Top