👻

AWS Athenaをさくっと使うためのCLI

2024/03/26に公開

AWS Athenaは結果を取ったりするのがちょっとめんどくさいので

https://github.com/tmtk75/athena-cli

master:athena-cli$ ./athena-cli
Usage:
  athena-cli [command]

Available Commands:
  get              Get an object from the s3 bucket with execution-id
  get-work-group   Show a work group
  help             Help about any command
  list             List all available executions
  list-catalogs    List all catalogs
  list-databases   List all databases
  list-work-groups List all work groups
  query            Execute query
  result           Show query reulst
  show-tables      Show all tables in .tsv or table metadata for given table name
  version

Flags:
      --catalog-name string      data catalog name (default "AwsDataCatalog")
      --database-name string     Athena database name
      --dry-run                  Dry-run only printing templated query.
  -h, --help                     help for athena-cli
      --output-location string   S3 URL for output, for instance, s3://your-bucket-name/path/to
      --timeout duration         Timeout ex) 30s (default 5s)
      --verbose                  Work verbosely
      --work-group string        Athena work group (default "primary")

Use "athena-cli [command] --help" for more information about a command.

Discussion