How to use Magnitude Simba drivers for BigQuery

[mikekaminsky]

👋 Hi -- i'm trying to set up henplus on my MacOS machine to be able to connect to BigQuery. I feel like there is a lot that I don't understand about how this is supposed to work so apologies if it is a dumb question.

I've downloaded and installed bigquery drivers from the google docs.

$ ls -l /Library/simba/googlebigqueryodbc/lib/
total 184016
-rwxrwxrwx  1 root  wheel       320 May  8 15:25 GoogleBigQueryODBC.did
-rwxrwxrwx  1 root  wheel    207949 May  8 15:25 cacerts.pem
-rwxrwxrwx  1 root  wheel  93996224 May  8 15:25 libgooglebigqueryodbc_sbu.dylib
-rwxrwxrwx  1 root  wheel       409 May  8 15:25 simba.googlebigqueryodbc.ini

I can't figure out how to tell henplus about these drivers -- there are no .jar files, so I'm not sure how to apply the directions in the docs to what I have here. Maybe it's impossible because these are .dylib and I need a .jar driver? If I'm just missing something stupid please let me know and I'd be happy to try to update the docs to help future folks avoid this issue.

[neurolabs]

Thanks Mike,

nobody ever tried this before. You could try https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.2.1004.zip and simply extract it. You might need to build a fat jar from all of the jars contained inside, I am unsure about the exact loading mechanism for the drivers.

BTW: As you can see, there is no big development going on, so don't expect much support. I certainly don't have much time nor do I have the need for an sql client currently.

[mikekaminsky]

Thanks @neurolabs! This is already more support than I was expecting. I'll give that a shot and if I do get it working I'll at least post back here.