Connect a new VPC to AWS Athena

[marklonghurst]

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]

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]

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}