Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

AWS Athena Compute Support

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.

13 Comments
benstroud
7 - Meteor

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
5 - Atom

YES Please!!!

justin_winter
8 - Asteroid

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
5 - Atom

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
Alteryx Alumni (Retired)
Status changed to: Accepted

Hi All,

 

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

 

Best,

Alex

justin_winter
8 - Asteroid

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

 

ARich
Alteryx Alumni (Retired)
Status changed to: Coming Soon
 
jeremy_kane
7 - Meteor

Hi Alex,

 

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

 

Thanks,

jineshnp31
8 - Asteroid

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

justin_winter
8 - Asteroid

@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.