vscode-sqltools
vscode-sqltools copied to clipboard
mtxr
Bigquery Support
Hi,
it would be great to have Google BigQuery support as well. There are ODBC and JDBC drivers for BQ:, maybe these would help?
https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers
Best Andreas
Hi, I second this. Support for BQ would simplify the number of IDE-like tools I need to open for my daily workflows. What would it take to add support for ODBC/JDBC drivers in this extension?
Community drivers can be created and there are useful docs to support this as well as a github template repository to start from.
The README.md also has this message:
I'm looking for maintainers for each driver, if you are interested on maintain/test any driver, please contact me. https://mteixeira.dev/
It won't use ODBC/JDBC, as a VSCode extension it is node.js/Typescript so would likely need to use the Google Bigquery Node.js Client
Has anyone made a start on this yet?
We're considering using SQL tools as part of the user experience at https://github.com/evidence-dev/evidence-VSCode
We're a Nodejs shop so may be able to help out
I am not aware of anyone working on this. Doing it in NodeJS is going to be a better fit than trying to leverage xDBC drivers, IMO.
Okay, so have a work in progress version up here:
Still quite a few issues to iron out, but it works to query data and explore the db
Hoping I can squash most of the bugs this week.
Once I have, would appreciate some testers if there are any around!
I've published a version 0.0.2 on the VSCode Marketplace
Squashed the bugs I found, and it's feeling pretty nice for me to drive around my DB
It has connection options for:
- Service Accounts
- GCloudCLI
- OAuth Access Token
Any testing much appreciated!
One thing I couldn't really get my head around was how to implement intellisense for column / table completions, but happy to leave that for later!