Install vdsql with BigQuery support - lmmx/devnotes GitHub Wiki

  • Go here and copy the link to the 64 bit CLI tarball

  • cd ~/opt, wget the tarball into the directory

tar -xf google-cloud-cli-*.tar.gz
rm google-cloud-cli-*.tar.gz
cd google-cloud-sdk
./install.sh
  • Accept all defaults (press enter)
gcloud init
# gcloud auth login

This should bring up the auth flow for Google Cloud SDK on your Google Cloud account (if you need to re-do it, run the commented out line)

You should then be able to run

vdsql bigquery:///bigquery-public-data

This should bring up the auth flow for Ibis Framework on your Google Cloud account

  • You may now see a DefaultCredentialsError:

google.auth.exceptions.DefaultCredentialsError: Your default credentials were not found. To set up Application Default Credentials, see https://cloud.google.com/docs/authentication/external/set-up-adc for more information.

To fix this use:

gcloud auth application-default login

This should bring up the auth flow for Google Auth Library on your Google Cloud account

At the time of writing if you install via the recommended route you get the incorrect result:

pip install numpy ibis-framework[bigquery] vdsql[bigquery]

Instead install from the tagged source then (as per the instructions in the README at visidata/apps/vdsql)

git clone --depth 1 [email protected]:saulpw/visidata.git --single-branch
pip install visidata
pip install visidata/visidata/apps/vdsql