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
    Use Secret Vault
    Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    When you enable the secret vault in the connection, you can select the credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    Note:
    If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
    For information about how to configure and use a secrets manager, see Secrets manager configuration.
    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.