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

0

Hello,

We have Amazon Connect CTRs streaming into Athena, and in Quicksight we refresh this Athena SQL view/SPICE every 30 minutes. We have a client request to email the report every 30 minutes (48 times per day); however, Quicksight only allows the report to be emailed daily. In addition, we would like the ability to FTP the data out of Athena/Qucksight every 30 minutes, similar to what we can do with Filezilla and S3.

I don't see where Athena query results or Quicksight Analysis/Dashboards are stored for access. How can we get this data emailed/FTPed every 30 minutes? Is there a way to copy an Athena query or Quicksight Analysis/Dashboards to S3 or similar for email/FTP access? Thank you.

John

asked a year ago303 views
2 Answers
0

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

answered a year ago
  • 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.

0

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

AWS
SUPPORT ENGINEER
Arun
answered a year 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