Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the BigQuery Adapter:

  • Access to Google Cloud Console.
  • A Google Cloud project with BigQuery enabled.
  • The project ID of the Google Cloud project.
  • An OAuth 2.0 client created in Google Cloud.
  • Client ID and client secret (visible only once during creation).
  • Required OAuth scopes. If multiple scopes are provided, separate them with a space, as defined in the BigQuery API documentation. See OAuth 2.0 Scopes for Google APIs.
  • Oracle Integration redirect URI added to the OAuth client configuration.
  • Create datasets and tables. See Create and use tables.

Locate the Project ID

  1. Sign in to the Google Cloud Console.
  2. Navigate to APIs & Services (API Console).
  3. From the project selector at the top, click Manage all projects.

    The list of projects is displayed.

  4. Locate your project in the list and note the corresponding project ID.

Create an OAuth Client in Google Cloud

To configure Authorization Code Credentials:

  1. Navigate to APIs & Services, then select Credentials.
  2. Click Create Credentials, and select OAuth client ID.
  3. Select Web Application as the application type.
  4. Enter a name for the OAuth client.
  5. Add the Oracle Integration redirect URI to the authorized redirect URIs list.
  6. Click Create to complete the configuration.

    Note:

    (Important)
    • The client secret is displayed only once during creation.
    • You can create multiple client secrets, but each secret is visible only at creation time.

Create a Dataset in BigQuery

  1. Sign in to the Google Cloud Console.
  2. Navigate to BigQuery.
  3. In the Explorer pane, select your project.
  4. Click Create Dataset.
  5. Enter the following details:
    • Dataset ID (must be unique within the project)
    • Data location (select your region)
  6. (Optional) Configure the following:
    • Default table expiration
    • Access controls
    • Encryption settings
  7. Click Create Dataset.

    The dataset is now available under your project.

Create a Table in BigQuery

  1. Sign in to the Google Cloud Console.
  2. Navigate to BigQuery.
  3. Select the required dataset.
  4. Click Create Table.
  5. Enter the table name.
  6. Define the schema (field names, data types, and modes).
  7. Click Create Table.