Configure your BigQuery warehouse

  • Updated

To configure a connection to BigQuery, complete the following:

Analytics-New connection.png

  1. Click Data > Connections.
  2. Click +New Connection. A window displays the data source types that your Analytics application can ingest.
  3. Click BigQuery.
  4. Configure the following fields:

    Analytics-BigQuery.png

    • Project ID – ID of the project that you want to connect. Use the same project in which the Service Account and the Role were created. You can also find this information in the JSON file downloaded in the previous step. Open the file and copy the value in the project_id field.
    • Service Account Email – The service account's email address. You can also find this information in the JSON file downloaded in the previous step. Open the file and copy the value in the client_email field.
    • Service Account Key JSON – Copy the entire content of the downloaded JSON file and paste it into the field provided.
  5. Click refresh to test the connection's configuration. If your configuration is successful, the icon turns green.
  6. Click Save.

Sample credentials

The following examples show the fields required when creating a BigQuery connection in Analytics:

  • Project ID – Paste the value corresponding to the Project ID field in your JSON file.

    • Example – stately-lodge-3613456

  • Service Account Email – Paste the email address from the Service Account Email field in your JSON file.

    • Example – netspring-byow@stately-lodge-3613456.iam.gserviceaccount.com

  • Service Account Key JSON – Paste the entire content from the Private Key field in your JSON file.

    • Example –

      {
      "type": "service_account",
      "project_id": "stately-lodge-3613456",
      "private_key_id": "6ae1360e16775af76163aa3891ccaffc08706d02",
      "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCo9zZ+kDmFbnS+\n0qHf6nb3M6JryOlrag7QKhkSYTuC0AkuqSGRiUcWDEMW33WhVtJshK3T9PacU6fB\np5cH75aKydBblOJgNT0t8DDDOviVGFhJs0o8ITZAjI4odVr0UWbYmehPb7tjMNV5\nlfz3RYFiCITLyTAS/Pt1FFvXkcwreQtARwqpixVNEqviHPFiUk5XuQPVNnZZsQzX\n4TJQxz1QycMoeMxm2D0OsfugF8DsdKc2ms0JUZ9lbMhmZKaCY1cVLi38JRkE+vfl\n4ZpxyUR31h9hNO2tSLRPJKdS1WcdI5XfekrfgU7WgPmaXVqcvll\nDYUyqOiFAgMBAAECggEAAIHWy8JZoBL3FU2Nx2TJ1do8qL3Vl8Idr5m4v+DDZT7Z\nZYpK+8fMNcXJwuCmD7AyaytOHvBeIrHhz9zyFmQtcQGLE7wv88UzXPqo+7NDVol0\nq7jaVJTgRfr+6ullDBwkcWOrjAO3yjlEIschM8LQCgAENnl/LtWhdSgC/QIqTo/C\n67dvj03Qbc0kiBJUPOGITi9fGuZypM+L0SSPkoQNaIefQX0KGCbEJPf1Iibh0k/Z\nCYxs0IRZvw3AJa6jcafLSb6vKqK6fFEtlTowWj0rEOay0AYDfKNIGs37YoXHnFHH\nc2IVRdZF17aeS5536DxSm0YUiCvNYlCMgcUEiOGSTwKBgQDnSKeqbk5N4XcjPjvX\nT2yrZOhsxqbp/cXw10XoZFFT6Ug7AejSnoZsSMF1vtiWRtiHe9djt8SEecH4zwAx\n8iJi37I2J3N/Vs1gnzl1B9grb/xv0FMS2GqQZ3XZ0zmLlUe3u0xzVTuTmAGDYsko\nTParajsksA30fxLeCPM/fwca2wKBgQC7BbCoEh7VqCuxR+IlJqTC6NMatzsMoxmA\ndvgywvHs/AjcFkXowu8uKcrL3VKTlcYI8lXqqL3+/opgtF9yhKpvWb2VYZcy9fjM\n5e6/bQYHOlSHFJ1ghszVyQ+mTuJRPno0r3EMLkPoPXMMe7GZt7IjeCuhy5M+i08h\n9UQGW4J4HwKBgQCWkwOtfrD2HUK+LCczbx8VmtWC8/X5QuGagdyehqk4ExmWaRDW\nBqUHXHqvGLfTZn5T/nllD2Aey1JQlRvQaI6ghnh0r0yPa8i8Dg2PNrMy3G6hsSRU\nkZcXOnRMgyrkyCRv5r3IHIZz+bOKgUbrOOgjAz9MDF6Zfh2fdn4/KYlLnwKBgFmo\nPqo0FagjuN6CMX3R6satyxZRpPNH9V/KqO3c2xHbOXwZCWaunO8qhdf5wC6UbJ25\nX0rhnkPyTvBRSDikNPiwstw8Lrn1hVLlH/GRGIS6h+9CCLhPpz8N5ny58HE2XGuJ\nd855F4DshI0Fd3zTvYiXgYNNDse7DTKgW/4YPJHNAoGAKa84YsiJC7DfgBNVPwyB\nyckawDHwo/UUe/YWTSkgqBOvY5DqAh+HiDASN5NbSSzBu4iRBc9rBB1j6Rng32IK\nPVZC6tJgWDJ5ly1SHd0rGsUAGjvqHN9x59MRR28o0ahaOzroV6wT68+bxdtDlcT9\nd2u6XTSBHCkVtK/tgsEJNEk=\n-----END PRIVATE KEY-----\n",
      "client_email": "netspring-byow@stately-lodge-363318.iam.gserviceaccount.com",
      "client_id": "110408766655969317177",
      "auth_uri": "https://accounts.google.com/o/oauth2/auth",
      "token_uri": "https://oauth2.googleapis.com/token",
      "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
      "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/netspring-byow%40stately-lodge-363318.iam.gserviceaccount.com"
      }