Download Amazon Athena JDBC Driver

Download the Amazon Athena JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

Connect Amazon Athena in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.

About the Amazon Athena JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Amazon Athena. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Amazon Athena driver uses its own syntax — see the connection details below.

The Amazon Athena JDBC driver

Amazon Athena is a serverless, interactive SQL query service that analyzes data stored in Amazon S3 directly using standard SQL. There is no infrastructure to manage — you pay only for the queries you run — making it ideal for ad-hoc data exploration and log analysis at petabyte scale.

The Amazon Athena JDBC URL

  • Required File(s): AthenaJDBC42.jar
  • Java Driver Class: com.amazon.athena.jdbc.AthenaDriver
  • JDBC URL: jdbc:awsathena://AwsRegion=REGION;S3OutputLocation=s3://BUCKET/PREFIX/
  • Website: Amazon Athena
We use the Amazon Athena driver.

Download Amazon Athena JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

DbSchema and Amazon Athena

DbSchema connects to Amazon Athena using the AWS JDBC driver and renders S3-backed Glue catalog tables and Iceberg tables as visual schemas. Use DbSchema's Query Builder to compose Athena SQL queries with partition pruning and nested data support.

Test the driver with DbSchema

Connect Amazon Athena, build your first ER diagram in minutes. No account required.

1
Download driver & DbSchema

Get the Amazon Athena driver zip below and install DbSchema for Windows, macOS, or Linux.

2
Register the .jar

In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.

3
Design & document

Reverse engineer Amazon Athena, edit the model visually, and publish schema documentation.

Use Amazon Athena visually in DbSchema

After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.

ER diagrams

Reverse engineer Amazon Athena into an interactive diagram and edit structures visually.

SQL & query builder

Run SQL with autocomplete or compose queries without writing every join by hand.

Schema documentation

Export HTML docs your team can browse without installing DbSchema.

Full Amazon Athena guide

Connection tips, ports, SSL, and schema design workflows on the database landing page.

Other drivers teams often configure alongside Amazon Athena.

Browse all JDBC driver downloads

Teams working with Amazon Athena often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases