keeper query

keeper query

Run a read-only query through the query proxy

keeper query <sandbox> [flags]

Examples

  keeper query sbx-1a2b -e "select count(*) from orders"
  keeper query sbx-1a2b -e "select * from orders" -o csv > orders.csv

Options

      --database string       database (default: the sandbox's)
  -e, --execute string        SQL to run (- or empty reads stdin)
  -h, --help                  help for query
  -o, --output string         output format: table, json, yaml or csv (default "table")
      --server keeper login   Keeper API URL (default: saved by keeper login, or $KEEPER_SERVER)
      --timeout duration      how long --wait waits (default 30m0s)
      --token string          Access token (default: saved, or $KEEPER_TOKEN)
      --write                 allow writes (sandbox only)

SEE ALSO

• keeper - Keeper: database backup and restore for Kubernetes