AWS Athena Compute Support

[brandonculver]

While I strongly support the S3 upload and download connectors, the development of AWS Athena has changed the game for us. Please consider opening up an official support of Athena compute on S3 like support already show for Teradata, Hadoop Hive, MS SQL, and other database types.

[benstroud]

AWS announced Athena API support: https://aws.amazon.com/about-aws/whats-new/2017/05/amazon-athena-adds-api-cli-aws-sdk-support-and-au...

Please consider adding first class query and export support for Athena to Alteryx.

[kell2604]

YES Please!!!

[justin_winter]

Yes! We use Athena a lot at our company and a native connector would be super helpful!

@benstroud @brandonculver @kell2604

If interested, check out my super elementary RJDBC Athena Macro here: https://community.alteryx.com/t5/Data-Sources/AWS-Athena/m-p/60876/highlight/false#M3969

It is NOT "first class" or highly performant, but it is serviceable in a bind and works fine for smallish datasets. Feel free to improve!

Thanks,

Justin

[flume-rush]

I am also very much hoping for this. We are using AWS for lots of data, and Athena is our preferred way of interacting with event/log data for analysts.

[ARich]

Hi All,

This is currently on the roadmap for Q1 2018 (though, timing could change).

Best,

Alex

[justin_winter]

AWS just announced ODBC support for Athena yesterday. You should be able to download the ODBC driver and connect via Alteryx:

http://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html

[jeremy_kane]

Hi Alex,

Could you confirm that will mean that Athena will have "In-Database" tool support?

Thanks,

[jineshnp31]

+1 for this feature! Any updates on the release for Athena connector? 

[justin_winter]

@jineshnp31

We have been using Alteryx against Athena for quite a bit and it works quite well using the ODBC connector. It doesn't have In-DB functionality yet, but it sounds like they are working on that. Again, not officially supported but it works fine as most other general ODBC connectors would.