- 최신
- 최다 투표
- 가장 많은 댓글
Hello,
I understand that you are using Athena connected to DocumentDB for the visualization of data in Quicksight but are experiencing a SQL_EXCEPTION error that you suspect is the result of a connection timeout between the two databases.
For Athena, there is a soft-limit 30-minute timeout and the Amazon QuickSight timeout for generating any visual is 2 minutes [1]. The timeout exception you are seeing may be related to an issue with the connector between the Athena and DocumentDB databases.
In order to remediate this issue, check to make sure there are no issues with the networking configuration. As mentioned in this article [2]:
-
The security group of the DocumentDB database must allow the traffic of the SG of the lambda function through port 27017
-
The lambda must be in a private subnet and its routing table must send traffic to the internet through a NAT gateway
You might also want to refer directly to the documentation for the connector [3] and a tutorial on AWS Blogs that walks through the architecture of a similar use-case [4].
Links to documentation:
[1] Query timeout when using Athena with Amazon QuickSight - Amazon QuickSight (https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-athena-query-timeout.html)
[2] Get started with Athena federated queries and DocumentDB. | by Carlos Andres Zambrano Barrera | Globant | Medium (https://medium.com/globant/get-started-with-athena-federated-queries-and-documentdb-3ac66bef4ef)
[3] Amazon Athena DocumentDB connector - Amazon Athena (https://docs.aws.amazon.com/athena/latest/ug/athena-prebuilt-data-connectors-docdb.html)
[4] Visualize MongoDB data from Amazon QuickSight using Amazon Athena Federated Query | AWS Big Data Blog (https://aws.amazon.com/blogs/big-data/visualize-mongodb-data-from-amazon-quicksight-using-amazon-athena-federated-query/)
Please let me know if this response helps or if you have any other questions. If the above steps do not resolve your issue, I strongly encourage you to contact an AWS support engineer who will be able to assist you.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
have you tried to run the query in Athena? how long does it takes to return data?