How to read data from Athena (AWS) in Alteryx

Question

Hi

I'm looking for advice on how to read data from Athena.

Our data architect has imported Open Alex data (https://docs.openalex.org/) into AWS Athena, however we're struggling to work out how to bring it into Alteryx for analysis.

Has anyone successfully achieved this without Python, is ODBC the only way to do this? I've been advised that ODBC isn't ideal, but this is the first time I've had to setup something like this.

Ideally I'd want to use the In-Database or Input tools to bring this in. I can access S3 using the Download tool but this isn't the data we want, we need what's in Athena.

Previous thread I found: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/AWS-Athena/td-p/42208

Thanks,

Beth

Brinker · Answer

We connect using the odbc drive found on the AWS site. In a medium organisation it is slow for quering and we are getting time outs. We suspect it is a network issue or something to do with the drivers. We still haven't solved it. You can use the same odbc connection in the in-db tool but that is a generic odbc connection becasue Athena is not supported by the in-DB tool.