Quicksight email frequency >1day or location of Athena queries / Quicksight dataset?

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