GitHub - ahmadrosid/bq-cli: Run BigQuery query from terminal

Bigquery Cli

A little command line application to execute biquery from terminal.

Installation

Follow this docs to setup authentication using gcloud cli.

git clone https://github.com/ahmadrosid/bq-cli.git
cd bq-cli
go build
go install

Important Don't forget to set your google project id on env.

GOOGLE_PROJECT_ID=your-project-id

Example

Make sure

$ bq-cli query 'select created_at, id from bookings limit 3'
+----------------------+--------------------------------------+
|      CREATED AT      |                  ID                  |
+----------------------+--------------------------------------+
| 2017-12-15T08:21:15Z | fb1f456b-e132-4723-9075-ec67bc74433b |
| 2017-12-20T05:06:08Z | 274670ca-b1aa-40fd-8e3b-9d9d1441c32b |
| 2020-07-24T08:18:55Z | 03c13e25-8f12-49ee-a8e7-2c0c1fcc94e8 |
+----------------------+--------------------------------------+

Help

NAME:
   bq-cli - A cli app to execute bigquery from terminal.

USAGE:
   bq-cli [global options] command [command options] [arguments...]

COMMANDS:
   query, q  Execute biquery
   repl, i   Run interactive query
   help, h   Shows a list of commands or help for one command

GLOBAL OPTIONS:
   --help, -h  show help (default: false)