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

質問済み 2年前1185ビュー
1回答
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
回答済み 2年前
profile pictureAWS
エキスパート
レビュー済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ