Follow the steps about how to install new database drivers when setting up Superset locally via docker-compose.

Connecting to BigQuery

When adding a new BigQuery connection in Superset, you’ll need to add the GCP Service Account credentials file (as a JSON).

1. Create your Service Account via the Google Cloud Platform control panel, provide it access to the appropriate BigQuery datasets, and download the JSON configuration file for the service account.

1. Additionally, can connect via SQLAlchemy URI instead

   The connection string for BigQuery looks like:

   The resulting file should have this structure:

You should then be able to connect to your BigQuery datasets.

To be able to upload CSV or Excel files to BigQuery in Superset, you’ll need to also add the library.