Helper tools to query AWS Athena.
npm install little-owl
little-owl
can be used either as a command line tool or as a node library.
The cli requires the following environment variables to be set:
AWS_REGION
: Region where the S3 bucket and Athena queries will run (default isus-east-1
)AWS_ACCESS_KEY_ID
: AWS access keyAWS_SECRET_ACCESS_KEY
: AWS secret keyAWS_OUTPUT_BUCKET
: Bucket where query results are stored (default islittle_owl_athena_output
)
Usage
$ little-owl query <sql>
$ echo <sql> | little-owl query
Examples
$ little-owl query "SELECT count(*) from owls"
MIT - See LICENSE.md