By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Athena Query Editor - Network Failure

0

I've configured the Athena connection to a RDS SQL Server database using a JDBC driver. After choosing the Data Source the Database does not load and there is a "Network Failure" shown without any information. What might be the cause of such error or where I can find more information on how to solve such case? Enter image description here

Topics
AnalyticsDatabaseSecurity, Identity, & Compliance
Tags
Amazon AthenaAnalyticsDatabaseIAM PoliciesRDS Custom for SQL Server
Language
English
rePost-User-2183301
asked 2 years ago1.1K views
1 Answer
0

Could you check if there any CloudTrail logs to describe the network issue in details - https://docs.aws.amazon.com/athena/latest/ug/monitor-with-cloudtrail.html? Besides, could you also check the configuration "SubnetIds" of Lambda function (AthenaSqlServerConnector) for JDBC driver is in the same VPC to your RDS SQL Server, but also the Security Group and NACLs of RDS SQL Server is allowed to be accessed (inbound) from Lambda of your Security Group?

AWS
Bard Lan
answered 2 years 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

Relevant content