#big-query #service-account #gcp #command-line #command-line-tool #cli

bin+lib bq-rs

A CLI for querying BigQuery tables Project homepage: https://github.com/isaacadams/bq-rs

4 releases

0.2.4 Dec 6, 2024
0.2.3 Oct 29, 2024
0.2.2 May 27, 2024
0.1.7 May 25, 2024
0.1.1 Nov 25, 2023

#1131 in Command line utilities

Download history 8/week @ 2024-09-20 2/week @ 2024-09-27 122/week @ 2024-10-25 26/week @ 2024-11-01 6/week @ 2024-11-08 2/week @ 2024-11-15 157/week @ 2024-12-06 3/week @ 2024-12-13

160 downloads per month

MIT/Apache

53KB
1K SLoC

bq-rs

a command line utility for interacting with bigquery

Commands

Authenticate w/ Service Account

All the commands require authentication via service account. The path to the service account key json file can be passed into bq-rs via the --key argument.

bq-rs --key <SERVICE-ACCOUNT-KEY-PATH> ...

e.g. bq-rs --key ./key.json ...

Query

Bigquery tables can be queried and its results returned as CSV by using the query subcommand.

bq-rs <...ARGS> query <QUERY>

e.g. bq-rs --key ./key.json query "SELECT * FROM <project-id>.<dataset-id>.<table-id>"

Dependencies

~13–22MB
~402K SLoC