Which storage stage requires the INTEGRATION parameter for Snowpipe AUTO_INGEST?

• A. Only when configuring AUTO_INGEST for Amazon S3 stages using SNS.
• B. Only when configuring ERROR_INTEGRATION for Google Cloud Storage or Microsoft Azure stages
• C. Only when configuring AUTO_INGEST for Google Cloud Storage or Microsoft Azure stages
• D. Only when configuring ERROR_INTEGRATION for Amazon S3 stages using SNS.

Answer: (C)

Snowpipe auto-ingest needs a storage integration to securely access the cloud storage bucket. The INTEGRATION parameter on the stage is what ties the external stage to that stored credential set. For Google Cloud Storage and Microsoft Azure, that linkage is required so Snowflake can use the integration to access the bucket and respond to arrival events. In contrast, Amazon S3 with SNS-based auto-ingest uses the AWS notification mechanism and credentials differently, so the INTEGRATION parameter isn’t required in that case. So the requirement applies specifically to configuring auto-ingest for Google Cloud Storage or Microsoft Azure stages.