Class CSVOptions (2.20.0) 

CSVOptions()

Options that describe how to treat CSV files as BigQuery tables.

Inheritance

builtins.object > CSVOptions

Properties

allow_jagged_rows

bool: If :data:True, BigQuery treats missing trailing columns as null values. Defaults to :data:False.

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

allow_quoted_newlines

bool: If :data:True, quoted data sections that contain newline characters in a CSV file are allowed. Defaults to :data:False.

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

encoding

str: The character encoding of the data.

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

field_delimiter

str: The separator for fields in a CSV file. Defaults to comma (',').

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

quote_character

str: The value that is used to quote data sections in a CSV file.

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

skip_leading_rows

int: The number of rows at the top of a CSV file.

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

Methods

from_api_repr

from_api_repr(resource: dict)

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

Parameter
NameDescription
resource Dict[str, Any]

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

Returns
TypeDescription
CSVOptionsConfiguration 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.