DSS can connect to Google BigQuery through a JDBC driver developed by Simba.
- DSS only provides read support from BigQuery. Writing to BigQuery under any form is not supported.
- Java 8 is required
- Creating external datasets targeting BigQuery projects
- Reading data across all datasets and tables.
- Reading all BigQuery data types
- SQL notebook for interactive querying
- SQL query datasets
- SQL query recipes, executed in BigQuery (with a non-BigQuery output)
- All visual recipes (Group, Join, VStack, Window, Filter executed in BigQuery), with a non-BigQuery output
- Charts in Live mode on a BigQuery dataset
- Writing to a BigQuery dataset
- INSERT / CREATE statements in SQL notebook
- SQL script recipes
Installing the JDBC driver¶
- The JDBC Driver can be downloaded from https://cloud.google.com/bigquery/partners/simba-drivers/
- Choose the “JDBC 4.2-compatible” download (beware: do not choose ODBC but JDBC)
- Unzip the downloaded file
The JDBC driver is made of many JAR files, all of which are contained in the Zip file.
- Copy all of the JAR files to the
- Restart DSS
Connecting to BigQuery¶
DSS connects to BigQuery using Service Account-based authentication.
- You first need to create a Google Service Account
- Create a private key for this account, and download the corresponding JSON file
- Upload the JSON file somewhere on the DSS server
In the connection settings, you need to enter the absolute path (on the DSS server) to the credentials JSON file.
We recommend that you add an Advanced JDBC property:
- Value: 180