Overview - Python Connector for Google BigQuery

Overview

Python Connector for Google BigQuery is a connectivity solution for accessing the Google BigQuery data warehouse from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows and Windows Server.

GoogleSQL for BigQuery

The connector fully supports the BigQuery SQL dialects, data types, and query syntax, including functions, operators, and conditionals.

These are a few examples of supported BigQuery functions:

• Aggregate functions
• Array functions
• Datetime functions
• Navigation functions

Compatibility

• Python versions from 3.7 to 3.11
• SQLAlchemy
• pandas
• petl

Supported platforms

• Windows 32-bit and 64-bit
• Windows Server 32-bit and 64-bit

Note: For details on supported OS versions, check the compatibility page of your Python version.