---
id: sqlalchemy-bigquery
version: "1.17.2"
license: unclear
license_treatment: permissive
maintenance: active
---

# sqlalchemy-bigquery — SQLAlchemy dialect for BigQuery

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install sqlalchemy-bigquery
uv add sqlalchemy-bigquery
poetry add sqlalchemy-bigquery

## Description

SQLAlchemy Dialect for BigQuery
===============================

|GA| |pypi| |versions|

`SQLALchemy Dialects`_

- `Dialect Documentation`_
- `Product Documentation`_

.. |GA| image:: https://img.shields.io/badge/support-GA-gold.svg
   :target: https://github.com/googleapis/google-cloud-python/blob/main/README.rst#general-availability
.. |pypi| image:: https://img.shields.io/pypi/v/sqlalchemy-bigquery.svg
   :target: https://pypi.org/project/sqlalchemy-bigquery/
.. |versions| image:: https://img.shields.io/pypi/pyversions/sqlalchemy-bigquery.svg
   :target: https://pypi.org/project/sqlalchemy-bigquery/
.. _SQLAlchemy Dialects: https://docs.sqlalchemy.org/en/14/dialects/
.. _Dialect Documentation: https://googleapis.dev/python/sqlalchemy-bigquery/latest
.. _Product Documentation: https://cloud.google.com/bigquery/docs/


Quick Start
-----------

In order to use this library, you first need to go through the following steps:

1. `Select or create a Cloud Platform project.`_
2. [Optional] `Enable billing for your project.`_
3. `Enable the BigQuery Storage API.`_
4. `Setup Authentication.`_

.. _Select or create a Cloud Platform project.: https://console.cloud.google.com/project
.....

## AI interpretation — verify before relying

SQLAlchemy dialect that enables you to use BigQuery as a database backend through SQLAlchemy's ORM and query interface, supporting standard SQL operations on BigQuery datasets and tables.

Verdict: Production-ready dialect (Development Status 5) with active maintenance, no known vulnerabilities, and low install friction. Suitable for projects needing SQLAlchemy integration with BigQuery, though authentication and GCP project setup are prerequisites.

[View on SkillFed](https://skillfed.io/packages/sqlalchemy-bigquery) · [View on PyPI](https://pypi.org/project/sqlalchemy-bigquery/)