Google Big Query
- Install latest Incorta version. Visit Install and Upgrade Incorta for instructions.
- Set up a Google Cloud Service Account. If you do not already have an account, you can create a Google Cloud account here.
- Create a Google Cloud Project. After setting up your Google Cloud account, create a new project for Incorta, then add a data set and table to this new Google Project. This will be used to test the connection between Google and Incorta. Visit Identifying Projects on the Google Cloud site for additional help with setting up your project.
- Download Big Query Driver: Before connecting a Google BigQuery data source, you must first download and configure the BigQuery driver for Incorta. The driver is in a JAR file. The BigQuery JAR file must exist in both the CMC and the Incorta Services installation path.
- Add BigQuery as Data Source: Follow the instructions to add a new data source. When asked for the specific parameters in the New Data Source dialog, you will need to have the following information to complete the connection.
After you choose BigQuery as a data source, the New Data Source dialog will request these parameters:
- Client ID: This is found in the Key File as
- Private Key ID : You can find this value in the
private_key_idfield of your service account JSON file.
- Project ID: Unique identifier assigned to each Google Cloud project found in the Dashboard page of the Google Cloud Console.
- Google Service Account Email: Email address associated with the Google Service Account you are connecting. Example:
Private Key Path: Authenticates the Service Key Path. Private key path should include the full path. Example:
- Connection Pool: 30
- Connection Properties: Path of the JSON file key downloaded from Google Cloud Service accounts. Refer to Using a Google Service Account for more details.
- Download the Simba JDBC driver for BigQuery from this link.
Extract the zip file,
SimbaJDBCDriverforGoogleBigQuery42_22.214.171.1241, to the following installation paths:
- Ensure that all files under bigquery are .jar only.
After downloading the Simba JDBC driver for BigQuery, you will need to configure the driver in order to authenticate the connection between Incorta and your Google BigQuery service account.
To configure service account authentication:
- Set the
OAuthTypeproperty to 0.
- Set the
ProjectIDproperty to the name of your BigQuery project.
- Set the
OAuthServiceAcctEmailproperty to your Google service account email address.
- Set the
OAuthPvtKeyPathproperty to the full path to the key file that is used to authenticate the service account email address. This parameter supports keys in .pl2 or .json format.
See Using a Google Service Account on the Simba site for more details.
Visit the Create Service Account Key page at the Google API console site to download a JSON key file for the Service account you want to connect to Incorta.
- The Key file contains both the client ID and private key ID.
- The Driver class for the connection is:
The following is an example of a connection string authenticating a connection to a service account:
jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443; ProjectId=MyBigQueryProject;OAuthType=0; OAuthServiceAcctEmail=<Service Email Address>; OAuthPvtKeyPath=<Path to Key File>;
Example of Path to Key File parameter:
Example of the Service Email Address parameter:
For additional information on managing BigQuery service account credentials, visit Setting Up Authentication for Server to Server Production Applications on the Google Cloud site.