DbSchema is connecting to GoogleBigQuery using JDBC Drivers.
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database.
Usually they are provided by the same company which developed the database software.
DbSchema is an GoogleBigQuery Client which already includes
the GoogleBigQuery JDBC driver. DbSchema can configure the GoogleBigQuery JDBC URL and test the connectivity.
What is the JDBC URL?
The URL is a string (text) with a specific format containing information about the host where the database is running, the port, username, database name, etc.
The URL format is specific to each driver.
Any wrong character in the URL may make the database connectivity fail.
Therefore we recommend installing DbSchema and try to get connected, and you will find the JDBC URL in the connection dialog.
GoogleBigQuery JDBC Driver
- Required File(s): googlebigqueryjdbc42.jar
- Java Driver Class: com.simba.googlebigquery.jdbc42.Driver
- URL: jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=DB;OAuthType=1;
- Website: Google Big Query
Download Google BigQuery JDBC Driver
The driver files are compressed in a zip file.
for any issues with the driver, you can write to us.