I help administer an OOD environment and was curious if anyone knew of a tool or application that could work as a web based SQL workbench environment for AWS Athena.
I have briefly looked at Cloudbeaver’s community edition with some help from others here, but found it extremely difficult to include custom JDBC/ODBC drivers in the application build to support AWS Athena. Cloudbeaver reports that they support Athena drivers in their paid eddition, but I would like to do an exhaustive search of opensource or community based projects before settling for a licensed paid solution if I can.
I have also attempted to create an Apache Superset application because it comes with it’s SQL Lab tool that can easily use python’s SQL Alchemy to query against AWS Athena, but the issue with Superset is that it becomes fragile with the use of reverse proxy, dynamic application_root needed for ephemeral compute node hostnames, and sub pathing. This also seems to be somewhat of an issue in a few other applications or open source projects I’ve looked at.
So this is a general inquiry about if anyone else has found a web based SQL workbench tool that has worked for them, and is decently configurable for custom drivers and/or supports python’s SQL Alchemy. Thanks!