Snowflake Pipe creation with SNS topic fails with the following error : Invalid Parameter

Hi All- I am trying to create a snowflake pipe and it fails with the following error

090040 (XX000): Pipe Notifications bind failure "Invalid parameter: TopicArn (Service: Sns, Status Code: 400, Request ID: d7fbc360-1faf-5216-bfab-9f037f6ac63d): AwsErrorDetails(errorMessage=Invalid parameter: TopicArn, errorCode=InvalidParameter, serviceName=Sns)"

Here is a documentation for reference https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3.html#prerequisite-create-an-amazon-sns-topic-and-subscription

Can someone shed light on how to resolve this. Though this is a snowflake error but I believe it has to do with configs on AWS which is causing this error