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 questions

Having issues selecting columns in Timestream->Scheduled query - Can't save the query

Redshift MV issue – mv_version != NULL

use Redshift Spectrum to query both Redshift table and s3 file

Instance Scheduled for Retirement

Redshift Metric No Data Available.

EMR step failure Alerts Issue

Error while creating redshift serverless

AWS cloudformation - Redshift Cluster subnet group