Adding Google BigQuery data source (Data Virtualization)

The Google BigQuery data source requires specific information to create the connection to Data Virtualization.

Procedure

  1. Click Data > Data Virtualization > Data sources.
  2. Click Add connection > New connection to see a list of data sources that can be added to Data Virtualization.
  3. Select Google BigQuery data source connection.
  4. Enter the connection name and description and select one of the following methods to connect to the data source:
    • Copy and paste the content and path of the Google service account key file.
    • Specify the following information to connect by using a token:
      • The ID of the Google project.
      • The access token to access Google BigQuery.
      • The OAuth client ID and secret.
      • A token to refresh the access token when needed.
  5. Click Create to add the connection to the data source environment.

Results

You can now use your Google BigQuery database as a data source in Data Virtualization.