Skip to main content

Google BigQuery

Connect to BigQuery.

Configuration

The following values are needed to connect to BigQuery:

  • Token: Service account JSON token
  • Project the GCP project that contains the dataset
  • Dataset: the BigQuery dataset to pull tables from

Details about generating the JSON token can be found here.

Dataset field highlighted

In the example above, the Project is smiling-mark-328118. The Dataset field corresponds to the bigquery dataset, in the example above it would be test.

Datasets

By default, each table in the dataset will be automatically indexed as a dataset within Predibase.

Connection Query Template

CREATE CONNECTION bigquery_connection
CONNECTION_TYPE = bigquery
GCP_TOKEN = 'token'
PROJECT_NAME = 'project_name'
DATASET_NAME = 'dataset_name'