Question

0

199

Views

I need to create alerts based on the results returned by queries in Amazon Athena

I need to create alerts based on the results returned by queries in Amazon Athena. I don't see how I can do that now.

For example -

Schedule a query to be executed once an hour (I am not aware of a way to do this now)
Based on the results of the query (for example I would be checking the number of transactions the last hour), I might need to send an alert to someone that something may be wrong (number of transactions is too low).

I know this is different but I would do something similar, in SQL Server, using a SQL Server Agent job.

over 4 years ago · Santiago Trujillo

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-05-11T18:53:50.881Z

There is no in-built capability to run Amazon Athena queries on a schedule and send notifications. However, you could configure this using AWS services.

I would recommend:

Create an Amazon SNS topic that will receive notifications
- Subscribe recipients to the SNS topic (eg via email, SMS)
Create an Amazon CloudWatch Event that triggers on a cron schedule
Configure the Event to trigger an AWS Lambda function
Write code for the AWS Lambda function to:
- Run an Amazon Athena query
- Compare the result to desired values
- If the result is outside desired values, send a message to the Amazon SNS Topic

0

199

I need to create alerts based on the results returned by queries in Amazon Athena

1 answers

0

Find remote jobs

Andres GPT