Google BigQuery

Owned by Juliane Wetzel
Last updated: Nov 02, 2020

INFO

BigQuery is Google's fully managed data warehouse for petabyte analytics.

Prerequisites

Having the Avro Plugin Installed

INFO

In order to use the Google BigQuery connector make sure you have the plug-in 'Avro' installed.

Configuring Google BigQuery as a Connection

In order to import from Google BigQuery, you must first create a connection.

  1. Click the "+" button and select "Connection" or right-click in the browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
         or 
  2. Select "Google BigQuery" from the drop-down and confirm with "Next". The tab 'Connection Details' is opened.
     
  3. Select "Import/Export" from the drop-down 'Connection usage'.
     
  4. Select "IAM Authentication" from the drop-down 'Select authentication method'. 
    INFO: 'IAM Authentication' is the default authentication mode. No further information is necessary because it is set up in Google Cloud console.
     
  5. Enter the dataset for data import. 
     
  6. Enter the Google Cloud Storage URL for data export to BigQuery and confirm with "Next". The tab 'Save' opens.
    INFO: The bucket name must contain only lowercase letters, numbers, dashes, underscores and dots. Spaces are not allowed. 
     
  7. If needed, enter a description for your connection, and confirm with "Save". The dialog "Save Connection" opens.
     
  8. Select the folder you want to save the connection in, name the connection and confirm with "Save". The connection is saved. Configuring the connection is finished.
    Â