title: facing issue in triggering SQS notification from aws S3 to Snow PIPE
body: <p>I am new to Snowflake, Trying to notify the <code>snowpipe</code> when a file is placed in a s3 bucket and thru SQL event Notification the <code>snowpipe</code> needs to load the data into the respective table.</p>
  <p>Below are the steps I have followed.</p>
  <p>Step -1: created a table in Snowflake</p>
  <p><code>create table Customer_Notification (Id  Varchar(10),Name  Varchar(25) );</code></p>
  <p>Step -2: Created a File Format</p>
  <p><code>create or replace file format csv_Notification type = 'csv' compression = 'auto' field_delimiter = ',' record_delimiter = '\n' skip_header = 1 field_optionally_enclosed_by = '\042' null_if = ('\\N');</code></p>
  <p>Step - 3: Created an external Stage</p>
  <p><code>create stage Customer_Notification_S3 url = 's3://snow-flake-test/ContinuousDataLoad/CustomerNotification/' CREDENTIALS = (AWS_KEY_ID = '*******' AWS_SECRET_KEY = '**********') file_format = csv_Notification comment = 'feed CustomerNotification files';</code></p>
  <p>Step - 4: Create Pipe</p>
  <p><code>create or replace pipe Customer_Notification_pipe auto_ingest = true as copy into customer_Notification from @Customer_Notification_S3 file_format = csv_Notification pattern='.*customernotification.*[.]csv' ON_ERROR = 'CONTINUE';</code></p>
  <p>Step - 5 : Get the ARN Number</p>
  <p>show pipes; -- arn:aws:sqs:us-east-2:306559659303:sf-snowpipe-AIDAUOYDBFUT7Y5DFHK4K-RdvAOUMAMjYD8diWaS1eWw</p>
  <p>Step -6 : Open <code>aws</code> S3 bucket in the parent folder, click on properties to create an even notification .
  Event name - <code>customer_notification</code></p>
  <p>Prefix - optional - snow-flake-test/<code>ContinuousDataLoad</code>/<code>CustomerNotification</code>/</p>
  <p>Suffix - optional - .csv</p>
  <p>Event types - All object create events</p>
  <p>Destination - Selected SQS queue</p>
  <p>Enter SQS queue ARN
  SQS queue - arn:aws:sqs:us-east-2:306559659303:sf-snowpipe-AIDAUOYDBFUT7Y5DFHK4K-RdvAOUMAMjYD8diWaS1eWw</p>
  <p>Finally Saved the Event Notification</p>
  <p>I have followed the <code>abovesteps</code>, even after this, when a file is placed in the respective snow-flake-test/<code>ContinuousDataLoad</code>/<code>CustomerNotification</code>/ folder the pipe is not picking the file and not loading it.
  checked the pipe status too , it is in running state.
  NOTE :  I am in a role <code>Accountaadmin</code></p>
  <p>Could anyone please help me to figure out what is missing.</p>