I cooked up AWS Athena Connector for Dremio ( Beta). I was able to browse the tables, query data and join with other databases.
Very limited testing has happend.
Big thanks to Dremio-Snowflake connector as they have done extensive work on Yaml ( key to push down queries to the engine) and i have just cloned it
Let me know it works for you guys.