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

[greend]

This is an impressive extension and I use it all the time. I was wondering if there will be support for materialized views at some point? I noticed that I can view Views, Tables, and routines seamlessly, but I cannot locate any of my materialized views.

[archiewood]

If you file an issue on GitHub, next time i’m working on it I’ll take a look

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

[greend]

That's great to hear, @archiewood! I've added the issue to GitHub and will expound with more details and photos later.

Cheers