Connecting to Google BigQuery with DBeaver

0) Install DBeaver You can find installation instructions here. Make sure to install version 5.2.2 or later. If you haven’t updated to 5.2.2 or later you may use this post as a guide for connecting to BigQuery. 1) Create a new service account Instructions & details for creating a new service account can be found on Google’s website Grant your desired BigQuery permissions to your new service account Download the service account key 2) Create a new connection In the menu bar navigate to Database > New Connection Select BigQuery & press next Fill in project with the name of your BigQuery Project Optional, add additional projects in the subsequent field Select service-based Fill in the name of the service account ex: bigquery-demo@project_name.

Exploring Complex Types in BigQuery

Introduction Google’s BigQuery has support for complex types (arrays & structs) which are relatively new in analytical databases. While the ideas and of arrays and structs aren’t unique to BigQuery some of the syntax and capabilities are unique. In this post I’ll be going over what I’ve found to be the most useful patterns and tricks. Arrays Put plainly an array is a series of values of the same type stored within a single value.

Connecting to Google BigQuery with DBeaver with JDBC Drivers

Update (2018-10-07) Shortly after this post DBeaver was updated with a native connector. Please see this post for a more up to date connection instructions if you have updated DBeaver to 5.2.2 or later. 0) Install DBeaver You can find installation instructions here 1) Download the latest drivers You can find the latest drivers on Google’s website 2) Create a folder to store the drivers mkdir ~/.dbeaver-drivers/bigquery/ 3) Extract driver jars and move to the folder we made earlier 4) Create a New Driver in DBeaver Navigate to Database > Driver Manager > New Add all the files from ~/.