Which parameter is used for Snowpipe auto-ingest with AWS S3 stages?

• A. AWS_SNS_TOPIC
• B. INTEGRATION
• C. SNS_TOPIC
• D. SNOWSENSOR_TOPIC

Answer: (A)

Snowpipe auto-ingest relies on AWS S3 event notifications being published to an SNS topic so Snowflake can trigger a load when new files arrive. The parameter you specify in the pipe is the ARN of that SNS topic, stored as AWS_SNS_TOPIC. This tells Snowflake which topic to monitor for new objects and automatically invoke the pipe.

The other options don’t fit because: integration is about the storage integration used to access S3 (not the notification topic); SNS_TOPIC is not the recognized parameter name in Snowflake; and SNOWSENSOR_TOPIC is not a valid parameter. Ensure the SNS topic exists and that the Snowflake storage integration has the necessary permissions and that S3 is configured to publish to that SNS topic.