Google BigQuery (prebuilt connector)

To view this content in our official product documentation, click here.

Description

Google BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data.

API documentation

API documentation for Google BigQuery (used to build this connector) can be found via the link below:

{% embed url="https://cloud.google.com/bigquery/docs/reference/rest" %}

Authentication

When adding connector instances for Google BigQuery, the following authentication methods are supported:

• OAuth 2 (authorisation code)

OAuth 2 (authorisation code)

When a user chooses to add a connector instance using OAuth 2 (authorisation code) authentication, the credentials below are prompted:

Credential	Required?	Notes
State length	true	This is a numeric value which determines the length of a random string generated (behind the scenes) during the OAuth process, for verification purposes. Our suggested setting is 15.
Scope	true	The required scope to define what access permissions should be given to Patchworks.
Client ID	true	The client ID generated for Patchworks in Google BigQuery.
Client secret	true	The client secret generated for Patchworks in Google BigQuery.
Response authentication token key	true	Leave set to the default access_token.
Grant type	true	Leave set to the default authorization_code.
Response type key	true	Leave set to the default code.
Refresh grant type	true	Leave set to the default refresh_token.
Response refresh token key	true	Leave set to the default refresh_token.