Amazon Athena - ANSI SQL - Desktop Database Clients

Amazon Athena - ANSI SQL - Desktop Database Clients

Amazon's Athena big data service does have a browser based client.

However, using a desktop client can be handy, for saving queries etc.

Most JDBC or ODBC based clients should be compatible.

Below are some options I have used:

DBeaver [recommended] - FREE OSS - download

[newer]

Authentication: supports OAuth based authentication and the older key/secret based authentication

Data Grip [recommended] - PAID - JetBrains

SQL Workbench - FREE OSS - download

[older]

Authentication: with Athena, supports only simple secret/key authentication

Both tools use JDBC drivers - you can download those from Amazon