How to use aws athena using nodejs?

Question

Athena is analytics service for retrieving data from s3 using sql query.
I have queried data in s3 using t aws console
Need access to aws athena using nodejs code

Welcome to SO. Please read [What topics can I ask about](http://stackoverflow.com/help/on-topic) and [How to ask a good question](http://stackoverflow.com/help/how-to-ask) And [the perfect question](http://codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question/) And how to create a [Minimal, Complete and Verifiable example](http://stackoverflow.com/help/mcve) SO is **not a Tutorial or Library Finding service** — RiggsFolly, Jan 06 '17 at 10:56
I cant speak for NodeJS but in Python there is a module called Pyhive, and for a generic JDBC connection you have to use the Hive JDBC driver which is available from AWS, and requires some configuration. — Henry, Jan 06 '17 at 14:43

score 4 · Answer 1 · answered Feb 13 '17 at 08:30

I am using athena like following way in my nodejs project :

download JDBC driver from AWS. Create a connector.js file. npm install jdbc NPM. Paste followings:

var JDBC = require('jdbc');
var jinst = require('jdbc/lib/jinst');
 
if (!jinst.isJvmCreated()) {
  jinst.addOption("-Xrs");
  jinst.setupClasspath(['./AthenaJDBC41-*.jar']);
}
 
var config = {
  // Required 
  url: 'jdbc:awsathena://athena.*.amazonaws.com:443',
   // Optional 
  drivername: 'com.amazonaws.athena.jdbc.AthenaDriver',
  minpoolsize: 10,
  maxpoolsize: 100,
  properties: {
                s3_staging_dir: 's3://aws-athena-query-results-*/',
                log_path: '/logs/athenajdbc.log',
                user: 'access_key',
                password: 'secret_key'
   }
};
 
 
var hsqldb = new JDBC(config);
 
hsqldb.initialize(function(err) {
  if (err) {
    console.log(err);
  }
});

were you able to get the Execution ID after running the query? — Rodrigo Assis, Mar 16 '17 at 14:26

score 3 · Answer 2 · answered Jun 13 '17 at 23:06

3

Just use the Athena Service on the JS SDK.

Athena JS Documentation

AWS JS SDK

answered Jun 13 '17 at 23:06

Sua Morales

894
10
21

You might want to check this out cc @flair – Sua Morales Jun 15 '17 at 19:00
1

@CpILL did you check out the links? What didn't you understand? – Sua Morales Sep 28 '17 at 17:13

score 1 · Answer 3 · answered May 15 '20 at 02:04

1

You could use the athena-express module from here, as documented by AWS here

answered May 15 '20 at 02:04

mailtobash

2,310
3
15
17

score 0 · Answer 4 · edited Jul 26 '22 at 12:42

0

You need to use aws-sdk and athena-express dependencies,

There's a full working tutorial in this video I made: https://www.youtube.com/watch?v=aBf5Qo9GZ1Yac

edited Jul 26 '22 at 12:42

cigien

57,834
11
73
112

answered Jul 24 '22 at 13:25

SWIK

714
7
12

When linking to your own site or content (or content that you are affiliated with), you [must disclose your affiliation _in the answer_](/help/promotion) in order for it not to be considered spam. Having the same text in your username as the URL or mentioning it in your profile is not considered sufficient disclosure under Stack Exchange policy. Please add a disclosure to *all* your answers where you've linked to your own youtube videos. – cigien Jul 24 '22 at 18:57
Is there any sample disclosure format? Little bit confused about it. – SWIK Jul 26 '22 at 11:20
The disclosure doesn't need to be particularly formal. You just need to make it very clear in the answer itself that you're affiliated with the linked content. I've edited this answer to demonstrate how that can be done. Hope that clears it up. – cigien Jul 26 '22 at 12:44
Ok. Got it now. Thanks for help here. – SWIK Jul 26 '22 at 13:37

How to use aws athena using nodejs?

4 Answers4

Linked