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'