Accessing BigQuery via SQL Developer

0
votes

I am new to Google's BigQuery (BQ). I am looking for a way to use SQL Developer (SD) as my primary GUI.

I have tried setting up a third party JDBC, but it does not seem to work. I downloaded Google's JDBC drivers for BQ and tried setting it up as a third party connection in SD. It registers, but does not show on the create new connection.

It is supposed to show up as a new Connection Type tab, but nothing is shown.

Is it possible to access BigQuery with SQL Developer? If so, can anyone provide me with the correct steps to duplicate?

1
google-bigqueryoracle-sqldeveloper
as you are new to BigQuery - why not to start just with what the great stuff BigQuery Team provides you with already!? – Mikhail Berlyant
Though I can use the web gui, it is clunky and not the desirable. This is why I am looking to use a third party gui. – Jerry
try Goliath. It is available on Google Cloud Marketplace as a part of Potens.io . You can check product videos before jumping in :o) – Mikhail Berlyant
Mikhail - While Goliath looks good, I am looking at SQL developer because of its simplicity and cost. Free is hard to beat. – Jerry
P.S. Goliath is free for you to use. 14 days free trial is for Magnus only and even those 14 days are flexible depends on your use-cases – Mikhail Berlyant

1 Answers

0
votes

Have you tried the Simba Driver? It provides not only JDBC, but ODBC (3.8 is supported) as well.

Alternatively you can check this documentation on how to Access BigQuery Data as a Remote Oracle Database.