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.
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'