Docs
...
Connecting to Google BigQuery

Connecting to Google BigQuery in Data Virtualization

Last updated: Apr 23, 2025
Adding a connection to Google BigQuery in Data Virtualization

The Google BigQuery connector requires specific information to create a connection to it in Data Virtualization.

Procedure

To connect to Google BigQuery in Data Virtualization, follow these steps.

  1. On the navigation menu, click Data > Data virtualization. The Data sources page appears.

  2. Click Add connection > New connection to view a list of data sources.

  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.