Hello
I have been trying to setup a jdbc connection to Amazon Athena but my connection gets hung. Below is the line at which connection just hangs
Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.api.AJClient.AJClient(): +++++ enter +++++
Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.utilities.AJUtilities.createAwsCredentialsProvider(): +++++ enter +++++
Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.utilities.AJUtilities.createAwsStaticCredentialsProvider(): +++++ enter +++++
Sep 06 23:34:24.281 DEBUG 291 com.simba.athena.athena.api.AJClient.AJClient: Building Athena client with endpoint = 'https://athena.us-east-1.amazonaws.com:443' and region = 'us-east-1'.
Sep 06 23:34:24.289 TRACE 291 com.simba.athena.athena.api.AJClient.buildGlueClient(): +++++ enter +++++
Sep 06 23:34:24.290 DEBUG 291 com.simba.athena.athena.api.AJClient.buildGlueClient: Building Glue client with region = 'us-east-1'.
Sep 06 23:34:24.296 DEBUG 291 com.simba.athena.athena.api.AJClient.AJClient: Building Athena Streaming client with endpoint = 'https://athena.us-east-1.amazonaws.com:444' and region = 'us-east-1'.
Sep 06 23:34:24.302 TRACE 291 com.simba.athena.athena.api.AJClient.checkGlueSupport(): +++++ enter +++++
Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Performing AWS Glue availability detection.
Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Aws::Glue - GlueClient - getCatalogImportStatus +++++ enter +++++
Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Build a test AWS Glue Client with the retry policy.
Sep 06 23:34:24.302 TRACE 291 com.simba.athena.athena.api.AJClient.buildGlueClient(): +++++ enter +++++
Sep 06 23:34:24.303 DEBUG 291 com.simba.athena.athena.api.AJClient.buildGlueClient: Building Glue client with region = 'us-east-1'.
Connection URL - jdbc:awsathena://AwsRegion=us-east-1;
I also tried below URL
jdbc:awsathena://athena.us-east-1.amazonaws.com:443
I am using IAM user to connect using Account Key and Secret Key
thanks for responding and yes I have opened the ports on my security groups as well as added the correct policy for the user I am using to access the Athena. I am still not able to connect