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

[Knowledgecentre]

Great work! 

Is it possible to view Stored Procedures and Functions as in big query workspace?

[archiewood]

You must be a mind reader. Released that feature today

[michael-wise]

I can't seem to find a way to view views. I'm guessing that's not implemented?

thanks

[archiewood]

Hmm there should be a folder specifically for views.

If you can't, could you file an issue on github, and I'll take a look when I get around to the next release

https://github.com/evidence-dev/sqltools-bigquery-driver