Class CSVOptions (3.35.0)

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

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

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

str: The character encoding of the data.

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

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

Optional[Iterable[str]]: A list of strings represented as SQL NULL values in a CSV file.

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

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

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

Optional[google.cloud.bigquery.enums.SourceColumnMatch]: Controls the strategy used to match loaded columns to the schema. If not set, a sensible default is chosen based on how the schema is provided. If autodetect is used, then columns are matched by name. Otherwise, columns are matched by position. This is done to keep the behavior backward-compatible.

Acceptable values are:

SOURCE_COLUMN_MATCH_UNSPECIFIED: Unspecified column name match option.
POSITION: matches by position. This assumes that the columns are ordered
the same way as the schema.
NAME: matches by name. This reads the header row as column names and
reorders columns to match the field names in the schema.

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

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

Build an API representation of this object.