As part of SNS configuration, I followed all the steps mentioned in the link https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3.html#option-2-configuring-amazon-sns-to-automate-snowpipe-using-sqs-notifications. But still I don't see any message on SQS queue even though new file is dropped in S3 bucket. One thing I noticed that "Create subscriptions" steps are missing to add Snowflake SQS. I went ahead and added Snowflake SQS ARN in the subscription of the SNS topic but the status shows "Pending confirmation". I am not sure where we can approve this confirmation?? Any help on this greatly appreciated.
0 Answers
Related