Usages

Options

$ athenacli --help
Usage: athenacli [OPTIONS] [DATABASE]

  A Athena terminal client with auto-completion and syntax highlighting.

  Examples:
    - athenacli
    - athenacli my_database

Options:
  -e, --execute TEXT            Execute a command (or a file) and quit.
  -r, --region TEXT             AWS region.
  --aws-access-key-id TEXT      AWS access key id.
  --aws-secret-access-key TEXT  AWS secretaccess key.
  --s3-staging-dir TEXT         Amazon S3 staging directory where query
                                results are stored.
  --work_group TEXT             Amazon Athena workgroup in which query is run,
                                default is primary
  --athenaclirc FILE            Location of athenaclirc file.
  --profile TEXT                AWS profile
  --table-format TEXT           Table format used with -e option.
  --help                        Show this message and exit.

Connect to a database

Connect a specific database with AWS credentials, region name and S3 staging directory or work group. AWS credentials, region name and S3 staging directory are optional. You can set those variables in athenaclirc config file, and then run below command.

$ athenacli ddbtablestats

Exit athenacli

Press ctrl+d or type quit or exit.

Special Commands

Save ‘SELECT user_id, tweet_id from twitterfeed LIMIT 2’ as a favorite query called ‘q1’:

> \fs q1 SELECT user_id, tweet_id from twitterfeed LIMIT 2

Run the named query:

> \f q1

Execute a command (or a file)

Execute a command and quit:

$ athenacli -e 'show databases'

Execute a file and quit:

$ athenacli -e examples/create_table.sql