RedShift Scheduled Query Failure Alerting Issues

0

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

asked 2 years ago1233 views
1 Answer
0

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)

profile pictureAWS
answered 2 years ago
profile pictureAWS
EXPERT
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions