beekeeper-studio icon indicating copy to clipboard operation
beekeeper-studio copied to clipboard

Published 20 hours ago • verified publisher icon beekeeper-studio

Big Query support

Open danipolo opened this issue 5 years ago • 10 comments

Nice project guys, why not BigQuery support?

danipolo avatar May 07 '20 21:05 danipolo

If you can persuade google to give us a bunch of test credits I'll happily build a connection provider for it :-)

rathboma avatar May 07 '20 22:05 rathboma

how much do you need? 👯

danipolo avatar May 07 '20 23:05 danipolo

you just need to auth a credit card onto a google account and the first x (lots) of credits are free. Plenty to test GBQ

therustybear avatar May 26 '20 09:05 therustybear

I have a GCP trial account. I don't have time to dedicate to this right now, but when I do, my primary concern is on-going support for the platform. As we add new features to the app we'll want to test them against BigQuery. I'll also want to integrate BigQuery into my (upcoming) integration test suite.

So I'd need a more permanent way to test it :-)

rathboma avatar May 26 '20 14:05 rathboma

Did you ever get the GCP build env worked out? If not DM me on linkedin and I'll see what I can do to help out.

https://www.linkedin.com/in/dustinwilliamsatx/

go-dustin avatar Jan 14 '21 18:01 go-dustin

hey Matt -- I'm an avid BQ consumer as well. I'd be happy to help get some testing on here if Dustin connected you with some GCP resources

jbarneson avatar Jun 29 '21 20:06 jbarneson

Would love BQ to be a part of this, +1.

Stijn-Hoeke avatar Jan 24 '22 14:01 Stijn-Hoeke

+1 would help

nicodemus-opon avatar Apr 13 '22 10:04 nicodemus-opon

+1 here too. Then I could stop using DBeaver :)

adampresley avatar Aug 23 '22 19:08 adampresley

+1

MaxHalford avatar Sep 22 '22 07:09 MaxHalford

I'd become an Ultimate Edition Customer once it's done, this is the only missing feature I needed to uninstall DataGrip and only work with VSCode & Beekeeper Studio. (This should be a pro feature)

mickaelandrieu avatar Oct 28 '22 19:10 mickaelandrieu

Hola @rathboma,

I was wondering if you are taking any volunteers for this feature; I was just doing some research on what's out there and we can probably use Google's Nodejs client: https://github.com/googleapis/nodejs-bigquery. For integration testing this emulator looks promising https://github.com/goccy/bigquery-emulator ( I have not tried this yet).

I was doing a small poc with my gcp account and I was able to do a basic bigquery query with the above client using an IAM service account. Screenshot from 2023-05-02 21-02-18

chekolyn avatar May 03 '23 04:05 chekolyn

That's awesome! Would love to have you commit a barebones implementation -- we'd be happy to then take it over and tidy it up :-).

The real basics are - query execution, table listing, column listing, and table data fetch, with those 4 things Beekeeper is pretty usable.

rathboma avatar May 03 '23 16:05 rathboma

Sounds good; will focus on the basics.

chekolyn avatar May 04 '23 05:05 chekolyn

I just want to thank this implementation, I'm testing it, and looks amazing, if I may suggest some additions it would be great to be able to select additional projects, so you can run with resources and billing from one project in other projects your service account also has access.

Felix-Pedro avatar Sep 22 '23 13:09 Felix-Pedro

Thank you a lot for this new feature, I'm so happy to use BeekeeperStudio again \o/

mickaelandrieu avatar Jun 10 '24 12:06 mickaelandrieu