Class CSVOptions (3.23.0)

CSVOptions()

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

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

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

preserve_ascii_control_characters

bool: Indicates if the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '' to '') are preserved.

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

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

Methods

from_api_repr

from_api_repr(resource: dict) -> google.cloud.bigquery.external_config.CSVOptions

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

Parameter
Name Description
resource Dict[str, Any]

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

Returns
Type Description
CSVOptions 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.