Create a Google BigQuery connection

  • Versão de lançamento: Australia
  • Atualizado 12 de mar. de 2026
  • 1 min. de leitura

    • Establish a zero copy connection to the Google BigQuery data warehouse service in Zero Copy Connector Hub.

    Antes de Iniciar

    Role required: df_connection_admin

    Por Que e Quando Desempenhar Esta Tarefa

    Work with your data source admin to create a connection to Google BigQuery. For additional information about connecting to Google BigQuery, refer to the Google BigQuery documentation.

    Procedimento

    1. Navigate to the available primary connectors in Zero Copy Connector Hub in one of the following ways:
      • Navigate to All > Zero Copy Connector Hub > Available connectors > Primary connectors.
      • Navigate to Admin > Zero Copy Connector Hub > Available connectors > Primary connectors.
    2. Find the Google BigQuery connector and select Connect.
    3. On the form, fill in the fields.
      Tabela 1. New Google BigQuery Connection form
      Field Description
      Name and description
      Connection label Unique name for this connection. This helps in identifying the connection within your system.
      Connection name System-generated name based on the Connection label. This field cannot be modified once the connection is established.
      Short description Description of the connection explaining what it is about.
    4. Enter the full Google Cloud service account JSON key used for authentication.
      You can obtain the JSON key from the Google Cloud Console when you create a service account.
      OptionDescription
      Upload service account key
      1. Select Attach Service Account Key (JSON).
      2. Browse and select the file.
      Enter service key contents manually Copy and paste the contents of the file, ensuring the content begins with { and contains fields like "type", "project_id", and "private_key", and ends with }.

      For example:

      {
"type": "service_account",
"project_id": "your-project-id",
...
"private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
...
}
    5. Select Connect.

    Resultado

    A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

    O que Fazer Depois

    If the connection succeeds, configure data steward access on the Access Control tab. See Manage access to an established connection using roles.

    If the connection fails, verify the connection details with your data source administrator and try again.