Google BigQuery (prebuilt connector)

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:

BigQuery API  |  Google CloudGoogle Cloud

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		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		The required scope to define what access permissions should be given to Patchworks.
Client ID		The client ID generated for Patchworks in Google BigQuery.
Client secret		The client secret generated for Patchworks in Google BigQuery.
Response authentication token key		Leave set to the default access_token.
Grant type		Leave set to the default authorization_code.
Response type key		Leave set to the default code.
Refresh grant type		Leave set to the default refresh_token.
Response refresh token key		Leave set to the default refresh_token.