Which stage type is not valid for Snowpipe loading?

• A. Named internal stage
• B. External stage
• C. Table stage
• D. Local file system directory

Answer: (D)

Snowpipe pulls data automatically from a stage, not from a local file path. The stages Snowflake supports for this purpose are named internal stages, external stages, and table stages. A local file system directory exists on your machine and isn’t a Snowflake stage, so Snowpipe cannot monitor or read from it directly. If you have files on your local drive, you must first upload them to a stage (using PUT or a client integration), and then configure Snowpipe to ingest from that stage. Once the files are in a stage, Snowpipe can detect new files and load them into the target table.