Query and Explore BigQuery from VSCode

Google Cloud Data Analytics
, ,
1

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

4 Likes
2

Great work!

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

1 Like
3

You must be a mind reader. Released that feature today

archiewood_0-1699314298121.png
archiewood_0-1699314298121.png1556×966 79.4 KB

4

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

thanks

2 Likes
5

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

1 Like
6

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.

7

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

1 Like
8

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

Cheers