Add a Google BigQuery database connection

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

Follow these steps:

  1. Select Connections in the top navigation bar.

  2. In the Connections interface, select Add connection in the upper-right corner.

  3. In the Create Connection interface, 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.

    See Connection properties for details, defaults, and examples.

    Connection name

    Name your connection.

    Connection type

    Choose the Google BigQuery connection type.

    Project id

    The identification number given to particular project, 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.

    Cloud storage location

    Provide the GCS bucket and object location details.

    Staging database

    Specify the name of the staging database.

    Staging database project ID

    Specify the unique identification number given to staging database.

    Use proxy

    If required, to use a proxy, select the checkbox 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.

  1. Select Create connection.


Related information