BigQuery v1.0.0¶

Installation¶

The BigQuery driver can be installed with dbc :

dbc install bigquery

Pre-requisites¶

Using the BigQuery driver requires some setup before you can connect:

1. Create a Google Cloud account

2. Install the Google Cloud CLI (for managing credentials)

3. Authenticate with Google Cloud

   • Run gcloud auth application-default login

4. Create, find, or reuse a project and dataset (record these for later)

Connecting¶

To connect, replace my-gcp-project and my-gcp-dataset below with the appropriate values for your situation and run the following:

from adbc_driver_manager import dbapi

conn = dbapi.connect(
  driver="bigquery",
  db_kwargs={
      "adbc.bigquery.sql.project_id": "my-gcp-project",
      "adbc.bigquery.sql.dataset_id": "my-gcp-datase"
  }
)

Note: The example above is for Python using the adbc-driver-manager package but the process will be similar for other driver managers.

Feature & Type Support¶