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