Athena query from Lambda Function

Question

Is it recommended practice to invoke Athena (dynamic) query (not saved query) from Lambda function for a custom Dashboard Application?

Answer

Querying Athena from Lambda either from a saved/unsaved query may not make any difference for Custom Dashboard Application.

To improve the performance of querying Athena, refer to the following blog:

[+] Top 10 Performance Tuning Tips for Amazon Athena - https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-tips-for-amazon-athena/

And will recommend to refer this document for Lambda Best Practices:

[+] Best practices for working with AWS Lambda functions - https://docs.aws.amazon.com/lambda/latest/dg/best-practices.html

Relevant content