Query and Explore BigQuery from VSCode

[archiewood]

I recently built a VSCode extension for BigQuery as I got bored of hopping into the console every time I needed to check a column name or run a scratch query.

Posting as I thought others might find it helpful.

Connecting and running queries in VSCode

Features:

• Connect via the CLI, Service Account or OAuth
• Run queries and get results into VSCode
• Explore datasets, tables and columns in the sidebar
• View table contents by selecting them in the sidebar
• Completion for common keywords (e.g. SELECT, FROM, WHERE)

It's an open-source project, code on GitHub