Answer: CREATE PIPE

The CREATE PIPE command in Snowflake enables continuous data loading by creating a Snowpipe, which automatically loads data from files as soon as they become available in a stage. This provides near real-time data ingestion without manual intervention. Option A (COPY INTO) requires explicit execution for each load, Option B (PUT) is for uploading files to a stage, and Option D (GET) is for downloading files from a stage. The community discussion shows 100% consensus on C, with references to Snowflake documentation confirming that pipes provide continuous loading functionality.

Author: LeetQuiz Editorial Team