Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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


  • No labels