Skip to main content

AWS Athena


PyAthenaJDBC is a Python DB 2.0 compliant wrapper for the Amazon Athena JDBC driver.

The connection string for Amazon Athena is as follows:


Note that you'll need to escape & encode when forming the connection string like so:

s3://... -> s3%3A//...


You can also use the PyAthena library (no Java required) with the following connection string:


The PyAthena library also allows to assume a specific IAM role which you can define by adding following parameters in Superset's Athena database connection UI under ADVANCED --> Other --> ENGINE PARAMETERS.

{"connect_args":{"role_arn":"<role arn>"}}