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

app bq-rs

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

6 releases

new 0.1.6 Apr 22, 2024
0.1.4 Jan 3, 2024
0.1.3 Dec 21, 2023
0.1.1 Nov 25, 2023

#4 in #service-account

MIT/Apache

31KB
607 lines

bq-rs

a command line utility for interacting with the bigquery api

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>"

Release

  • change version in Cargo.toml
  • run bash scripts/release.sh
    • this will create a git tag based on the version in Cargo.toml and push the tag
  • release workflow will kick off, generate cross platform binaries, and put everything into a github release

Dependencies

~12–23MB
~421K SLoC