How to execute query over Amazon Athena with Ruby?

Question

how to connect Amazon Athena with Ruby and execute query over Amazon Athena and get result.

we not able to find any gem or example with help us to connect Amazon Athena in ruby.

Please provide any reference using which we can use to build connection with Amazon Athena and build a custom query executor in Ruby.

just to clarify my application on production so changing SDK from Ruby to JRuby is not a suitable option for me.

Answer 1

Per May 19th 2017, Amazon Athena supports query execution via SDK and CLI.

Ruby API client for Athena documentation @ docs.aws.amazon.com

Source code of aws-sdk-athena @ github.com/aws/aws-sdk-ruby

Answer 2

I found that the official Amazon SDK for athena was a bit complicated, so I made a new gem called Athens that wraps the SDK in a nicer interface:

conn = Athens::Connection.new(database: 'sample')
query = conn.execute("SELECT * FROM mytable")