Google BigQuery

Create a connection

Ensure that you have a working connection. Connections are type-specific and depend on the connected external data source. Enable the BigQuery Connection API.

Ensure that you can view a list of service accounts in your project. BigQuery creates and uses a service account to connect to your external data source. When you create a connection, a Google Cloud–managed Identity and Access Management (IAM) service account is created on your behalf. To view the service account attached to a particular connection, view the connection details.

You'll need to provide us with your:

• Project Name

• Service Account Credentials in JSON

Credential Requirements

Quest requires these permissions to execute BigQuery extracts:

• BigQuery Data Viewer

• BigQuery User

• BigQuery Job User

Configure in Quest

You can test the connection to ensure the credentials were entered properly and are working. An error message will appear if the credentials are not working properly, with some hints as to why we may not be able to connect.