Snowpipe auto ingestion

Question

I'm new to Snowflake. I have created snowpipe, stages also configured SQS in AWS.

Data is not getting loaded into table through snowpipe when I placed files in my S3 bucket.

If I'm executing statement: alter pipe snow_pipename refresh then only data getting loaded into table.

Do I need to do any more setup/instructions for auto ingest data load.

Answer 1

The SQS notification might not have been set up properly on the S3 bucket. Check the configuration to set it up in the below link

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3.html#step-4-configure-event-notifications