search

aws-quickstart / quickstart-apache-superset

AWS Quick Start Team
Apache License 2.0
38 stars 31 forks source link

Connect a new VPC to AWS Athena #47

Open marklonghurst opened 2 years ago

marklonghurst commented 2 years ago

Please would someone be able to confirm if there are any additional steps required to connect superset, deployed into a new VPC, to Athena. I've tried to use the Athena+rest connection string, with a key:secret extracted from an IAMs administration user - the same user used to create the S3 bucket and AWS GLUE/Lake Formation.

I am currently hitting the following popup error when trying to test the database connection "Failed to Fetch Results" - wondering if I'm missing some steps to make AWS Athena available to the VPC.

Any help appreciated, Cheers

yike5460 commented 2 years ago

It seems networking issue judging by the description and more info are needed for VPC/S3 configuration, e.g. can the VPC access the external network, is S3 private or public, any policy attached?

marklonghurst commented 2 years ago

I've added a VPC Endpoint for Athena into my VPC and pointed it to the public Subnets. I can managed to make a connection to the Athena using the presto connector but not the athena connector. awsathena+rest://{awsuser}:{awsuserkey}@athena.eu-west-2.amazonaws.com:443/{athena_db}?s3_staging_dir={s3-location-set-in-athena}