Google BigQuery connector

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


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.


  1. Choose an option:

  • If you want to create a dataset, click Catalog > Datasets and click the New dataset button.

  • If you want to add a source to an existing dataset, click Catalog > Datasets and select the desired dataset. Then, click Add a source.

  1. 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

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

  2. Configure the dataset information or use the pre-filled 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.