Skip to main content
Version: Next

confirm_subscription

Method to confirm an SNS subscription

Returns following columns:

  • arn: The ARN of the subscription that has been confirmed
  • status: status of the trigger call. OK if succeeded
  • error: Error message in case of failure

Accepts the following parameters:

  • arn: The ARN of the topic for which you wish to confirm a subscription.
  • token: Short-lived token sent to an endpoint during the Subscribe action.
  • region: Region where the subscription is stored

Example

SELECT * FROM confirm_subscription('<arn>', '<token>');

See

https://docs.aws.amazon.com/sns/latest/dg/sns-create-subscribe-endpoint-to-topic.html