tenax query

tenax query

Run a read-only query through the query proxy

tenax query <sandbox> [flags]

Examples

  tenax query sbx-1a2b -e "select count(*) from orders"
  tenax 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 tenax login   Tenax API URL (default: saved by tenax login, or $TENAX_SERVER)
      --timeout duration     how long --wait waits (default 30m0s)
      --token string         Access token (default: saved, or $TENAX_TOKEN)
      --write                allow writes (sandbox only)

SEE ALSO

• tenax - Tenax: database backup and restore for Kubernetes