Google BigQuery SQL Script Sources > Before you begin > Create a connection
  

Create a connection

Create a Google BigQuery connection object in Administrator with the connection details of the Google BigQuery source system.
    1In Administrator, select Connections.
    2Click New Connection.
    3In the Connection Details section, enter the following connection details:
    Connection property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    4Select the Google BigQuery V2 connection type.
    5Enter properties specific to the Google BigQuery connection:
    Property
    Description
    Runtime Environment
    The execution platform that runs tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
    Authentication Type
    Select the Service Account authentication type to access Google BigQuery and configure the authentication-specific parameters.
    Service Account Email
    The client_email value from the Google service account key JSON file.
    Service Account Key
    The private_key value from the Google service account key JSON file.
    To use the private key from the JSON file, enter the entire block of text found within the double quotation marks in the private_key field, starting with -----BEGIN PRIVATE KEY-----\n and ending at -----END PRIVATE KEY-----\n.
    Project ID
    The project_id value from the Google service account key JSON file.
    If you have created multiple projects with the same service account, enter the ID of the project that contains the dataset that you want to connect to.
    Connection mode
    The mode that you want to use to read data from or write data to Google BigQuery. Choose the Hybrid connection mode for optimum data profiling results.
    Use Legacy SQL for Custom Query
    Select this option to use a legacy SQL to define a custom query. If you clear this option, use a standard SQL to define a custom query. Clear this option for optimum data profiling results.
    Retry Strategy Section
    Enable or disable retry. When you read data from Google BigQuery in staging mode, you can configure the retry strategy when the Google BigQuery V2 connection fails to connect to the Google BigQuery source.
    6Click Test Connection.
    7Click Save.