BigQuery support

[stokedout]

We support a variety of relational databases, such as MySQL, PostgreSQL, Oracle, etc.

Hey, wondering if you support BigQuery?

[XGenerationLab]

Yes, BigQuery is supported through its SQLAlchemy dialect.

How to use it:

1. Install the dialect

pip install python-bigquery-sqlalchemy 

2. Create an engine just like any other SQLAlchemy backend

from sqlalchemy import create_engine

engine = create_engine(
    "bigquery://<project_id>/<default_dataset>",
    credentials_path='/path/to/keyfile.json'
)

For details and advanced options, please see the official dialect repo: python-bigquery-sqlalchemy