By using AWS re:Post, you agree to the Terms of Use

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

1 Answers
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 picture
answered 13 days ago
profile picture
EXPERT
reviewed 10 days 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