why is my notification channel (External table )null?

Question

I have created a external table in snowflake with data in S3. and automated it with SNS.

I have created S3 integration object with 2 buckets (Bucket1 and BUcket 2).

I have created a SNS topic and subscripted the same topic to both S3 buckets.

when I click on Show external tables I am getting null in notification_channel for the data that is being from bucket 2:

I am able to do a ls on that path and also able to manually refresh the stage, but is not updating automatically.

What might cause this issue?

Answer 1

Adding a condition to the topic access policy like below to include all the buckets works

 "Action": "SNS:Publish",
//      "Resource": "<sns arn>",
//      "Condition": {
//        "ArnLike": {
//          "AWS:SourceArn": "arn:aws:s3:*:*:*"
//        }
//      }