Package dbapi (1.25.0)

API documentation forbigquery.dbapi package.

Classes

Connection

DB-API Connection to Google BigQuery.

Cursor

DB-API Cursor to Google BigQuery.

DataError

DB-API error due to problems with the processed data.

DatabaseError

DB-API error related to the database.

Error

Exception representing all non-warning DB-API errors.

IntegrityError

DB-API error when integrity of the database is affected.

InterfaceError

DB-API error related to the database interface.

InternalError

DB-API error when the database encounters an internal error.

NotSupportedError

DB-API error for operations not supported by the database or API.

OperationalError

DB-API error related to the database operation.

These errors are not necessarily under the control of the programmer.

ProgrammingError

DB-API exception raised for programming errors.

Warning

Exception raised for important DB-API warnings.

Packages Functions

Binary

Binary(string)

Contruct a DB-API binary value.

Parameter
NameDescription
string

A string to encode as a binary value.

DateFromTicks

DateFromTicks(timestamp,/)

Create a date from a POSIX timestamp.

The timestamp is a number, e.g. created via time.time(), that is interpretedas local time.

TimeFromTicks

TimeFromTicks(ticks,tz=None)

Construct a DB-API time value from the given ticks value.

Parameters
NameDescription
ticks

a number of seconds since the epoch; see the documentation of the standard Python time module for details.

tz

(Optional) time zone to use for conversion

TimestampFromTicks

timestamp[, tz] -> tz's local time from POSIX timestamp.

connect

connect(client=None,bqstorage_client=None)

Construct a DB-API connection to Google BigQuery.

Parameters
NameDescription
client

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

bqstorage_client

[Beta] An alternative client that uses the faster BigQuery Storage API to fetch rows from BigQuery. If both clients are given,bqstorage_client is used first to fetch query results, with a fallback onclient, if necessary. .. note:: There is a known issue with the BigQuery Storage API with small anonymous result sets, which results in such fallback.https://github.com/googleapis/python-bigquery-storage/issues/2

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

Last updated 2025-12-16 UTC.