Amazon Athena Connector

The high-performance Amazon Athena Connector provides read/write capabilities within your application, allowing you to perform numerous Amazon Athena operations with minimal coding or even no-coding at all. Integrate Amazon Athena data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download

Integrate Amazon Athena with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

SQL examples for Amazon Athena Connector

Use these example Amazon Athena SQL queries within SSIS, SQL Server or any ODBC-compatible application:

Query Amazon Route 53 logs in descending query_timestamp order 

SELECT * FROM "r53_rlogs"
ORDER BY query_timestamp DESC

Query Amazon EMR step logs for occurrences of ERROR, WARN, INFO, EXCEPTION, FATAL, or DEBUG 

SELECT data,
        "$PATH"
FROM "default"."myemrlogs"
WHERE regexp_like("$PATH",'s-86URH188Z6B1')
        AND regexp_like(data, 'ERROR|WARN|INFO|EXCEPTION|FATAL|DEBUG') limit 100;

Create an external table to query JSON data 

CREATE EXTERNAL TABLE `planets_json`(
  `name` string,
  `distancefromsun` double,
  `orbitalperiod` double,
  `daylength` double)
ROW FORMAT SERDE
  'org.openx.data.jsonserde.JsonSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
LOCATION
  's3://amzn-s3-demo-bucket/json/''

Query JSON via created external table 

SELECT * FROM planets_json

Download