snowflake-cloud-data-platformamazon-snssnowflake-schemaexternal-tables

why is my notification channel (External table )null?

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:

enter image description here

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?

Solution

  • 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:*:*:*"
//        }
//      }