Package dbapi (1.25.0)

Version 1.25.0

• 3.21.0 (latest)
• 3.20.1
• 3.19.0
• 3.18.0
• 3.17.2
• 3.16.0
• 3.15.0
• 3.14.1
• 3.13.0
• 3.12.0
• 3.11.4
• 3.4.0
• 3.3.6
• 3.2.0
• 3.1.0
• 3.0.1
• 2.34.4
• 2.33.0
• 2.32.0
• 2.31.0
• 2.30.1
• 2.29.0
• 2.28.1
• 2.27.1
• 2.26.0
• 2.25.2
• 2.24.1
• 2.23.3
• 2.22.1
• 2.21.0
• 2.20.0
• 2.19.0
• 2.18.0
• 2.17.0
• 2.16.1
• 2.15.0
• 2.14.0
• 2.13.1
• 2.12.0
• 2.11.0
• 2.10.0
• 2.9.0
• 2.8.0
• 2.7.0
• 2.6.2
• 2.5.0
• 2.4.0
• 2.3.1
• 2.2.0
• 2.1.0
• 2.0.0
• 1.28.2
• 1.27.2
• 1.26.1
• 1.25.0
• 1.24.0
• 1.23.1
• 1.22.0
• 1.21.0
• 1.20.0
• 1.19.0
• 1.18.0
• 1.17.0
• 1.16.0

API documentation for bigquery.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

Name	Description
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 interpreted as local time.

TimeFromTicks

TimeFromTicks(ticks, tz=None)

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

Parameters

Name	Description
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

Name	Description
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 on client, 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