Google BigQuery connector

You need a Google BigQuery account to use the Google BigQuery connector. You also need to create a service account in the project containing the table you need to access and create a key for this account.

The Google BigQuery connector retrieves files from a Google BigQuery table.

1. Create a new dataset or add a source to an existing one. In the wizard that opens, select Google BigQuery under the "Configure a remote service" section.

2. Select an existing Google BigQuery connection or create a new connection.

3. If you want to create a new connection, fill the following informations:

• Email address

• Private key

• Project ID

• Dataset ID

• Table ID

4. Check the preview showing the first 20 records of the table.

5. Configure the dataset information or use the prefilled values:

• In the Dataset name field, enter the title for this dataset.

• In the Dataset technical identifier field, enter a meaningful identifier for this dataset.