athenacli

This is a simple CLI tool for executing queries against AWS Athena. This scratches a personal itch as the AWS CLI is cumbersome to work with for this use case and the alternatives seem predominantly to be in scripting languages that require more setup than I'd like.

This is simple to include in scripts and can run queries either passed in via an argument or from a file and is a statically-compiled binary for extra simple deployments.

Usage

``` $ athenacli --help athenacli 0.1.0 Basic Athena CLI

USAGE: athenacli [FLAGS] [OPTIONS] --database --region --results

FLAGS: -h, --help Prints help information -V, --version Prints version information -v Logging verbosity (repeat for more detail)

OPTIONS: -c, --command run only single SQL statement and exit -d, --database database name to connect to -f, --file execute an SQL statement from file, then exit -r, --region AWS region [env: AWS_REGION=] -b, --results S3 bucket name for results (eg s3://my-results) -w, --workgroup Athena workgroup to use ```

Authentication

This uses the standard methods for discovering AWS credentials, it'll check the environment, ~/.aws/config and look for EC2 metadata (I think in that order..)

Contributions

Contributions are welcome - feel free to submit a PR!

License

MIT