Connect a new VPC to AWS Athena
marklonghurst opened this issue · 2 comments
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
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?
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}