Class GoogleSheetsOptions (3.27.0) 

GoogleSheetsOptions()

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

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: dict,
) -> google.cloud.bigquery.external_config.GoogleSheetsOptions

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

Parameter
Name Description
resource Dict[str, Any]

Definition of a .external_config.GoogleSheetsOptions instance in the same representation as is returned from the API.
Returns
Type Description
GoogleSheetsOptions Configuration parsed from resource.

to_api_repr

to_api_repr() -> dict

Build an API representation of this object.

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