- Más nuevo
- Más votos
- Más comentarios
Thank you Arun. It seems part1 is resolved in that Quicksight can be set to refresh every 30 minutes, so now it's finding the Object and emailing it. The challenge is that is uses manifest format (bucket/reports/yyyy/mm/day/name) and then a random object name.
I am wondering if EventBridge searching for a new object/PUT and then an action of SES would work, or if it's just easier to use Lambda to listen to a new object in an S3 bucket and then follow the email example you provided? I assume the second option, but since I don't code in lambda I thought I'd ask. Thanks again.
John
There is no direct method to schedule a query from Athena. However, we can indirectly achieve this by using a “Lambda function” as illustrated in [1]. Once the query gets executed and the query result gets stored in output location, you can programatically email it using python functions (an open source example can be referred from [2]).
————————
Reference:
[1] https://aws.amazon.com/premiumsupport/knowledge-center/schedule-query-athena/
[2] https://stackoverflow.com/questions/3362600/how-to-send-email-attachments
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
In addition, a 3rd party solution is to use Shipyard as it can run an Athena query every 30 mins and email out the results.