Google BigQuery
Before you begin
Additionally, you must set permissions for your BigQuery and Google Cloud accounts. To configure your service account authentication, see https://www.simba.com/products/BigQuery/doc/v1/JDBC_InstallGuide/content/jdbc/bq/authenticating/serviceaccount.htm.
Procedure
Stop the Pentaho Server.
Download the ZIP file containing the Simba JDBC 4.2 driver for Google BigQuery from https://cloud.google.com/bigquery/partners/simba-drivers.
Extract the following files to the server/pentaho-server/tomcat/webapps/pentaho/WEB-INF/lib folder for the User Console or the design-tools/data-integration/lib directory for the PDI client:
- GoogleBigQueryJDBC42.jar
- google-http-client-1.22.0.jar
- google-http-client-jackson2-1.22.0.jar
- google-oauth-client-1.22.0.jar
- google-api-client-1.22.0.jar
- google-api-services-bigquery-v2-rev355-1.22.0.jar
NoteThe Google BigQuery connection name will not display in the User Console Database Connection dialog box until you copy these files.Restart the Pentaho Server.
Log on to the User Console or the PDI client, then open the Database Connection dialog box.
See Define Data Connections for more information.In the Database Connection dialog, select General, then Google BigQuery as the Database Type.
In the Settings area, enter the information for your Google BigQuery account.
- The Host Name is the URL to Google's BigQuery web services API. For example, https://www.googleapis.com/bigquery/v2
- The Project ID (in the PDI client) and the Database name (in the User Console) are identical.
- The Port Number should be 443.
Click Options and add the following parameters and values:
Parameter Value OAuthType 0 (Zero) OAuthServiceAcctEmail Specify your service account email address OAuthPvtKeyPath Specify the path to your private key credential file Timeout Specify the amount of time, in seconds, before the server closes the connection. The recommended value is 120 seconds Click Test to verify that you can connect to your data.