Class GoogleSheetsOptions (2.11.0)

GoogleSheetsOptions()

Options that describe how to treat Google Sheets as BigQuery tables.

Inheritance

builtins.object > GoogleSheetsOptions

Properties

range

str: The range of a sheet that BigQuery will query from.

See https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#GoogleSheetsOptions.FIELDS.range

skip_leading_rows

int: The number of rows at the top of a sheet that BigQuery will skip when reading the data.

See https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#GoogleSheetsOptions.FIELDS.skip_leading_rows

Methods

from_api_repr

from_api_repr(resource)

Factory: construct a .external_config.GoogleSheetsOptions instance given its API representation.

Parameter
NameDescription
resource Dict[str, Any]

Definition of a .external_config.GoogleSheetsOptions instance in the same representation as is returned from the API.

Returns
TypeDescription
GoogleSheetsOptionsConfiguration parsed from ``resource``.

to_api_repr

to_api_repr()

Build an API representation of this object.

Returns
TypeDescription
Dict[str, Any]A dictionary in the format used by the BigQuery API.

__init__

__init__()

Initialize self. See help(type(self)) for accurate signature.