How to create a notification subscription for an event in AWS RedShift

Question

Hi Team,

I have one RedShift Cluster in AWS. I want to create a notification subscription for an event in the cluster. How can I do that with CLI command?

Answer 1

Hi@akhtar,

You can create an Amazon Redshift event notification subscription. This action requires an ARN of an Amazon SNS topic created by either the Amazon Redshift console, the Amazon SNS console, or the Amazon SNS API. The following create-event-subscription example creates an event notification subscription.

aws redshift create-event-subscription \
    --subscription-name mysubscription \
    --sns-topic-arn arn:aws:sns:us-west-2:123456789012:MySNStopic \
    --source-type cluster \
    --source-ids mycluster