Google BigQuery connector

The Google BigQuery connector retrieves records from one or more Google BigQuery tables.

To use this connector, you must have a Google Cloud service account with access to the BigQuery table you want to retrieve.

Create and download a key for this service account in JSON format. You will need the values of the client_email and private_key properties from the downloaded file.

When adding a source, select Google BigQuery under "Configure a remote service."

Select an existing Google BigQuery connection or create a new one. When creating a new connection, enter the service account credentials used to connect to Google BigQuery.

Then identify the table or tables you want to retrieve.

The connection contains the service account credentials used to access Google BigQuery. Once the connection has been saved, you can reuse it for other BigQuery sources that the same service account is allowed to access.

• Account email: Copy the value of the client_email property from the service-account JSON key file.

• Private key: Copy the complete value of the private_key property from the service-account JSON key file, including the BEGIN PRIVATE KEY and END PRIVATE KEY lines. Do not paste the complete JSON file.

These parameters identify the BigQuery table or tables used as the source. They are specific to this source and are not part of the reusable connection.

• Project ID: Enter the ID of the Google Cloud project containing the BigQuery dataset. Use the project ID, not the project name or numeric project number.

• Dataset ID: Enter the ID of the BigQuery dataset containing the table. Dataset IDs can contain only letters, numbers, and underscores (_). Spaces and hyphens are not accepted.

• Table ID: Enter the ID of the table to retrieve. In Huwise, the value can contain only letters, numbers, and underscores (_).

Use the preview to confirm that Huwise is retrieving the expected data from the selected table or tables. The preview displays the first 20 records.