# Google BigQuery

## Create a connection

Ensure that you have a working [connection](https://cloud.google.com/bigquery/docs/connections-api-intro). Connections are [type-specific](https://cloud.google.com/bigquery/docs/connections-api-intro#connection_types) 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](https://cloud.google.com/iam/docs/service-accounts-list-edit#listing). BigQuery creates and uses a [service account](https://cloud.google.com/iam/docs/service-agents) to connect to your external data source. When you create a connection, a [Google Cloud–managed Identity and Access Management (IAM) service account](https://cloud.google.com/iam/docs/service-account-types#google-managed) is created on your behalf. To view the service account attached to a particular connection, [view the connection details](https://cloud.google.com/bigquery/docs/working-with-connections#view-connections).

You'll need to provide us with your:

* `Project Name`
* `Service Account Credentials` in JSON

## Credential Requirements

Questera AI requires these [permissions](https://cloud.google.com/bigquery/docs/access-control#bq-permissions) to execute BigQuery extracts:

* BigQuery Data Viewer
* BigQuery User
* BigQuery Job User

## Configure in Questera AI

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.