Skip to main content
Genloop connects to BigQuery over an encrypted (HTTPS) connection using a Google Cloud service account. You provide the service account key and the dataset you want Genloop to read.

Before you connect

  • A Google Cloud service account with read access to your data.
  • The dataset you want Genloop to query.

Connection fields

Set up a service account

1

Open Service Accounts

In the Google Cloud Console, go to IAM & Admin → Service Accounts.
2

Grant read roles

Create or select a service account and grant it BigQuery Data Viewer and BigQuery Job User.
3

Create a JSON key

Create a key for the service account, download the JSON file, and upload it in the Genloop connection form.

Encryption and network

Genloop reaches BigQuery over the internet using an encrypted (HTTPS) connection. There is no SSL setting to configure, and an SSH tunnel is not used. Control access through the service account’s roles rather than a network allowlist.

Permissions

Genloop only reads your data. The service account you provide needs read access to the datasets you want to query. If you want a dedicated service account for Genloop, ask your Google Cloud administrator to grant it the roles below.
Grant the service account:
  • bigquery.dataViewer on the datasets you want Genloop to query.
  • bigquery.jobUser on the project to run queries.

Next steps

Connect a database

Back to the full connection flow.

Context Hub

View and edit the memory built from your connection.