Which stage types does Snowpipe support for loading data?

• A. Named internal or external stages
• B. Only named internal stages
• C. Only external stages
• D. Table stages

Answer: (A)

Snowpipe loads data from stages, which are locations where files are prepared before loading into Snowflake. These stages can be internal (stored inside Snowflake) or external (pointing to cloud storage like S3, Azure, or GCS). Snowpipe is designed to work with either type, using a pipe to automatically ingest new files as they appear in the stage. Because both named internal stages and named external stages are valid sources for Snowpipe, the correct statement is that Snowpipe supports loading data from both. The other options limit the sources or refer to a concept that isn’t used as a separate stage type for Snowpipe.