Snowpipe supports which types of stages in Snowflake?

• A. Named internal stages from Snowflake
• B. External stages like Amazon S3, Google Cloud Storage, or Microsoft Azure
• C. Table stages
• D. All of the above

Answer: (D)

Snowpipe can pull data from any Snowflake stage, and those stages come in a few flavors. It works with named internal stages that Snowflake manages, external stages that point to cloud storage like Amazon S3, Google Cloud Storage, or Microsoft Azure (with the proper credentials), and even table stages that are linked to a specific table. Since Snowpipe can ingest from all of these stage types, the option that says all of the above is the correct one. In practice, you choose the stage based on where your incoming files live and the credentials you’ve set up, but Snowpipe’s ingestion paths support each of these.