RedShift Scheduled Query Failure Alerting Issues

Question

Hi Team,

I am having issues while creating alerts for RedShift Scheduled Query.

Service : AWS RedShift
Region : us-east-1(N. Virginia).

Exact Issue :

When we schedule a query in RedShift there we can enable the monitoring and it will send alerts for all the triggered queries but, I want whenever a query fails it should alert us.

Looking forward to hearing from you soon.

Thanks & Regards,
Abhi
sabhi8226@gmail.com

Answer

Amazon SNS topics attached to a scheduled query is currently designed to only send out notifications every time the query gets triggered, but do not come with the additional details (like query failure or success).

To verify if a schedule query is a success or failure, we have the option to check (using CLI) as of now using redshift-data API 'describe-statement'. (https://docs.aws.amazon.com/redshift-data/latest/APIReference/API_DescribeStatement.html)

RedShift Scheduled Query Failure Alerting Issues

Relevant content