Add a Google BigQuery database connection

You can add a connection to a Google BigQuery database using ThoughtSpot DataFlow.

Follow these steps:

  1. Click Connections in the top navigation bar.

  2. In the Connections interface, click Add connection in the top right corner.

  3. In the Create Connection interface, enter the Connection name, and select the Connection type.

  4. After you select the Google BigQuery Connection type, the rest of the connection properties appear.

    Depending on your choice of authentication mechanism, you may use different properties.

    • Project id
      The identification number given to particular project and its always unique.

    • Authentication type
      It can be either Service Account or Access Tokens

    • Service account key/access Token
      Provide the Service Account key when authentication type is selected as Service account and token when access token is selected as authentication type.

    • Query priority
      Specify the time duration to run the query and it can be either Interactive or Batch.

    • Use proxy+ If required, to use a proxy, select the check box Use Proxy and provide the details

    • Host
      Specify the hostname or the IP address of the BigQuery system For proxy authentication only.

    • Port
      Specify the port associated to the BigQuery system For proxy authentication only.

    • Protocol
      It can be either http or https For proxy authentication only.

    • JDBC options
      Specify the options associated with the JDBC URL.

    See Connection properties for details, defaults, and examples.

  5. Click Create connection.