Class Connection (2.30.1) 

Connection(client=None, bqstorage_client=None)

DB-API Connection to Google BigQuery.

Parameters

Name Description
client Optional[google.cloud.bigquery.Client]

A REST API client used to connect to BigQuery. If not passed, a client is created using default options inferred from the environment.

bqstorage_client Optional[google.cloud.bigquery_storage_v1.BigQueryReadClient]

A client that uses the faster BigQuery Storage API to fetch rows from BigQuery. If not passed, it is created using the same credentials as client (provided that BigQuery Storage dependencies are installed). If both clients are available, bqstorage_client is used for fetching query results.

Inheritance

builtins.object > Connection

Methods

close

close()

Close the connection and any cursors created from it.

Any BigQuery clients explicitly passed to the constructor are not closed, only those created by the connection instance itself.

commit

commit()

No-op, but for consistency raise an error if connection is closed.

cursor

cursor()

Return a new cursor object.

Returns
Type Description
google.cloud.bigquery.dbapi.Cursor A DB-API cursor that uses this connection.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年10月30日 UTC.