athena-aws-v3

athena-aws-v3 is a simple Node.js package that allows you to execute Athena queries on AWS. It uses the AWS SDK for JavaScript (v3) to manage the execution of your queries and fetch the results directly from S3 CSV files without waiting much time.

Features

• Async/Await for managing query execution
• Handles AWS Athena queries
• Allows you to set your output location on S3
• Fetches all rows of the result set

Installation

Use the package manager npm to install athena-aws-v3.

npm install athena-aws-v3

Usage

You can use this package in your JavaScript code like this:

const athenaService = require('athena-aws-v3');

const config = {
  region: 'your-aws-region', // e.g. 'us-west-2'
  // Add other necessary AWS SDK configuration
};

const athena = new athenaService(config);

const query = 'SELECT * FROM mytable';
const s3Location = 's3://my-bucket/my-folder';
const databaseName = 'mydatabase';
const workGroup = 'myWorkGroup';

const result = await athena.executeAthenaQuery(query, s3Location, databaseName, workGroup);

Please ensure that you replace 'your-aws-region', 'SELECT * FROM mytable', 's3://my-bucket/my-folder', and 'mydatabase' with your actual AWS region, Athena query, S3 location for query results, and Athena database name respectively.

Error Handling

In case the Athena query execution fails, the executeAthenaQuery function throws an error with a message specifying the query status returned from AWS Athena.

Configuration

The constructor of the athena-aws-v3 class accepts an AWS SDK configuration object. This configuration is passed directly to the underlying Athena client from @aws-sdk/client-athena. For more details on the options available, check out the AWS SDK for JavaScript documentation.

Limitations

• The package currently only supports querying databases in Athena, with the results written to a specified S3 location.
• It assumes that you have the necessary AWS credentials available in your environment or through your configuration.