Download GoogleBigQuery JDBC Driver

Download the GoogleBigQuery JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the GoogleBigQuery JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to GoogleBigQuery. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each GoogleBigQuery driver uses its own syntax — see the connection details below.

The GoogleBigQuery JDBC driver

Google BigQuery is a fully managed, serverless data warehouse that enables super-fast SQL queries against multi-petabyte datasets. It uses a columnar storage format (Capacitor) and a massively parallel query engine, making it ideal for BI, ML feature engineering, and large-scale reporting.

The Google BigQuery JDBC URL

• Required File(s): googlebigqueryjdbc42.jar
• Java Driver Class: com.simba.googlebigquery.jdbc42.Driver
• JDBC URL: jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=DB;OAuthType=1;
• Website: Google BigQuery

Download Google BigQuery JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

DbSchema and Google BigQuery

DbSchema maps BigQuery datasets and tables into visual ER diagrams, helping analysts understand the relationships between fact and dimension tables in a data warehouse schema. Use the SQL Editor to write BigQuery Standard SQL with partitioning filters, nested STRUCT queries, and ARRAY aggregations.