Returns whether BigQuery should accept rows that are missing trailing optional columns. If
true, BigQuery treats missing trailing columns as null values. If false,
records with missing trailing columns are treated as bad records, and if the number of bad
records exceeds ExternalTableDefinition#getMaxBadRecords(), an invalid error is
returned in the job result.
Returns the character encoding of the data. The supported values are UTF-8 or ISO-8859-1. If
not set, UTF-8 is used. BigQuery decodes the data after the raw, binary data has been split
using the values set in #getQuote() and #getFieldDelimiter().
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Class CsvOptions (2.54.1)\n\nVersion latestkeyboard_arrow_down\n\n- [2.54.1 (latest)](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.CsvOptions)\n- [2.54.0](/java/docs/reference/google-cloud-bigquery/2.54.0/com.google.cloud.bigquery.CsvOptions)\n- [2.53.0](/java/docs/reference/google-cloud-bigquery/2.53.0/com.google.cloud.bigquery.CsvOptions)\n- [2.52.0](/java/docs/reference/google-cloud-bigquery/2.52.0/com.google.cloud.bigquery.CsvOptions)\n- [2.51.0](/java/docs/reference/google-cloud-bigquery/2.51.0/com.google.cloud.bigquery.CsvOptions)\n- [2.50.1](/java/docs/reference/google-cloud-bigquery/2.50.1/com.google.cloud.bigquery.CsvOptions)\n- [2.49.0](/java/docs/reference/google-cloud-bigquery/2.49.0/com.google.cloud.bigquery.CsvOptions)\n- [2.48.1](/java/docs/reference/google-cloud-bigquery/2.48.1/com.google.cloud.bigquery.CsvOptions)\n- [2.47.0](/java/docs/reference/google-cloud-bigquery/2.47.0/com.google.cloud.bigquery.CsvOptions)\n- [2.46.0](/java/docs/reference/google-cloud-bigquery/2.46.0/com.google.cloud.bigquery.CsvOptions)\n- [2.45.0](/java/docs/reference/google-cloud-bigquery/2.45.0/com.google.cloud.bigquery.CsvOptions)\n- [2.44.0](/java/docs/reference/google-cloud-bigquery/2.44.0/com.google.cloud.bigquery.CsvOptions)\n- [2.43.3](/java/docs/reference/google-cloud-bigquery/2.43.3/com.google.cloud.bigquery.CsvOptions)\n- [2.42.3](/java/docs/reference/google-cloud-bigquery/2.42.3/com.google.cloud.bigquery.CsvOptions)\n- [2.41.0](/java/docs/reference/google-cloud-bigquery/2.41.0/com.google.cloud.bigquery.CsvOptions)\n- [2.40.3](/java/docs/reference/google-cloud-bigquery/2.40.3/com.google.cloud.bigquery.CsvOptions)\n- [2.39.1](/java/docs/reference/google-cloud-bigquery/2.39.1/com.google.cloud.bigquery.CsvOptions)\n- [2.38.2](/java/docs/reference/google-cloud-bigquery/2.38.2/com.google.cloud.bigquery.CsvOptions)\n- [2.37.2](/java/docs/reference/google-cloud-bigquery/2.37.2/com.google.cloud.bigquery.CsvOptions)\n- [2.36.0](/java/docs/reference/google-cloud-bigquery/2.36.0/com.google.cloud.bigquery.CsvOptions)\n- [2.35.0](/java/docs/reference/google-cloud-bigquery/2.35.0/com.google.cloud.bigquery.CsvOptions)\n- [2.34.2](/java/docs/reference/google-cloud-bigquery/2.34.2/com.google.cloud.bigquery.CsvOptions)\n- [2.33.2](/java/docs/reference/google-cloud-bigquery/2.33.2/com.google.cloud.bigquery.CsvOptions) \n\n public final class CsvOptions extends FormatOptions\n\nGoogle BigQuery options for CSV format. This class wraps some properties of CSV files used by\nBigQuery to parse external data. \n\nInheritance\n-----------\n\n[Object](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html) \\\u003e [FormatOptions](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions) \\\u003e CsvOptions \n\nInherited Members\n-----------------\n\n[FormatOptions.avro()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_avro__) \n[FormatOptions.bigtable()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_bigtable__) \n[FormatOptions.csv()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_csv__) \n[FormatOptions.datastoreBackup()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_datastoreBackup__) \n[FormatOptions.equals(Object)](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_equals_java_lang_Object_) \n[FormatOptions.getType()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_getType__) \n[FormatOptions.googleSheets()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_googleSheets__) \n[FormatOptions.hashCode()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_hashCode__) \n[FormatOptions.iceberg()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_iceberg__) \n[FormatOptions.json()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_json__) \n[FormatOptions.of(String)](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_of_java_lang_String_) \n[FormatOptions.orc()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_orc__) \n[FormatOptions.parquet()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_parquet__) \n[FormatOptions.toString()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_toString__) \n[Object.clone()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#clone--) \n[Object.finalize()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#finalize--) \n[Object.getClass()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#getClass--) \n[Object.notify()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notify--) \n[Object.notifyAll()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notifyAll--) \n[Object.wait()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait--) \n[Object.wait(long)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-) \n[Object.wait(long,int)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-int-)\n\nStatic Methods\n--------------\n\n### newBuilder()\n\n public static CsvOptions.Builder newBuilder()\n\nReturns a builder for a CsvOptions object.\n\nMethods\n-------\n\n### allowJaggedRows()\n\n public Boolean allowJaggedRows()\n\nReturns whether BigQuery should accept rows that are missing trailing optional columns. If\n`true`, BigQuery treats missing trailing columns as null values. If `false`,\nrecords with missing trailing columns are treated as bad records, and if the number of bad\nrecords exceeds [ExternalTableDefinition#getMaxBadRecords()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.ExternalTableDefinition#com_google_cloud_bigquery_ExternalTableDefinition_getMaxBadRecords__), an invalid error is\nreturned in the job result.\n\n### allowQuotedNewLines()\n\n public Boolean allowQuotedNewLines()\n\nReturns whether BigQuery should allow quoted data sections that contain newline characters in a\nCSV file.\n\n### equals(Object obj)\n\n public boolean equals(Object obj)\n\n**Overrides** \n[FormatOptions.equals(Object obj)](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_equals_java_lang_Object_)\n\n### getEncoding()\n\n public String getEncoding()\n\nReturns the character encoding of the data. The supported values are UTF-8 or ISO-8859-1. If\nnot set, UTF-8 is used. BigQuery decodes the data after the raw, binary data has been split\nusing the values set in [#getQuote()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.CsvOptions#com_google_cloud_bigquery_CsvOptions_getQuote__) and [#getFieldDelimiter()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.CsvOptions#com_google_cloud_bigquery_CsvOptions_getFieldDelimiter__).\n\n### getFieldDelimiter()\n\n public String getFieldDelimiter()\n\nReturns the separator for fields in a CSV file.\n\n### getNullMarker()\n\n public String getNullMarker()\n\nReturns the string that represents a null value in a CSV file.\n\n### getPreserveAsciiControlCharacters()\n\n public Boolean getPreserveAsciiControlCharacters()\n\nReturns whether BigQuery should allow ascii control characters in a CSV file. By default ascii\ncontrol characters are not allowed.\n\n### getQuote()\n\n public String getQuote()\n\nReturns the value that is used to quote data sections in a CSV file.\n\n### getSkipLeadingRows()\n\n public Long getSkipLeadingRows()\n\nReturns the number of rows at the top of a CSV file that BigQuery will skip when reading the\ndata.\n\n### hashCode()\n\n public int hashCode()\n\n**Overrides** \n[FormatOptions.hashCode()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_hashCode__)\n\n### toBuilder()\n\n public CsvOptions.Builder toBuilder()\n\nReturns a builder for the `CsvOptions` object.\n\n### toString()\n\n public String toString()\n\n**Overrides** \n[FormatOptions.toString()](/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.FormatOptions#com_google_cloud_bigquery_FormatOptions_toString__)"]]
