Executing Amazon Athena Queries Directly from JetBrains PyCharm IDE

Audio Version of the Post

Amazon Athena

Athena Query Editor

Demonstration of Amazon Athena.

Full-Featured IDE

Athena Integration with PyCharm

Demonstration of querying Amazon Athena from PyCharm.

Downloading the Athena JDBC Driver

Installation Guide

Creating a New Athena Driver

The Amazon Athena Driver General tab.
The Amazon Athena Driver Options tab.

Creating a New Athena Data Source

jdbc:awsathena://AwsRegion=your-region;S3OutputLocation=s3://your-bucket-name/query-results-path

Data Access

Querying Athena from PyCharm

Saving Queries and Exporting Results

Athena Query History

Other IDEs

AWS Solutions Architect | AWS Certified Pro | Polyglot Developer | Data Analytics | DataOps | DevOps

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store