I am using Redshift scheduled queries to run an UNLOAD command. I would like to receive a notification if the query fails. I enabled SNS, but the message is the same regardless of if the job succeeds of fails. How can I receive a notification only if the job fails?
Update: I am able to get a response with the error message using the below command. How do I set up CloudWatch or some other service to monitor for this and send a notification?
aws redshift-data describe-statement --id {id} --region us-west-2