[Optional] If sourceFormat is set to ‘AVRO’, indicates whether to
interpret logical types as the corresponding BigQuery data type (for
example, TIMESTAMP), instead of using the raw type (for example,
INTEGER).
[[["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-20 UTC."],[],[],null,["Version latestkeyboard_arrow_down\n\n- [3.36.0 (latest)](/python/docs/reference/bigquery/latest/format_options)\n- [3.35.1](/python/docs/reference/bigquery/3.35.1/format_options)\n- [3.34.0](/python/docs/reference/bigquery/3.34.0/format_options)\n- [3.33.0](/python/docs/reference/bigquery/3.33.0/format_options)\n- [3.31.0](/python/docs/reference/bigquery/3.31.0/format_options)\n- [3.30.0](/python/docs/reference/bigquery/3.30.0/format_options)\n- [3.29.0](/python/docs/reference/bigquery/3.29.0/format_options)\n- [3.27.0](/python/docs/reference/bigquery/3.27.0/format_options)\n- [3.26.0](/python/docs/reference/bigquery/3.26.0/format_options)\n- [3.25.0](/python/docs/reference/bigquery/3.25.0/format_options)\n- [3.24.0](/python/docs/reference/bigquery/3.24.0/format_options)\n- [3.23.1](/python/docs/reference/bigquery/3.23.1/format_options)\n- [3.22.0](/python/docs/reference/bigquery/3.22.0/format_options)\n- [3.21.0](/python/docs/reference/bigquery/3.21.0/format_options)\n- [3.20.1](/python/docs/reference/bigquery/3.20.1/format_options)\n- [3.19.0](/python/docs/reference/bigquery/3.19.0/format_options)\n- [3.18.0](/python/docs/reference/bigquery/3.18.0/format_options)\n- [3.17.2](/python/docs/reference/bigquery/3.17.2/format_options)\n- [3.16.0](/python/docs/reference/bigquery/3.16.0/format_options)\n- [3.15.0](/python/docs/reference/bigquery/3.15.0/format_options)\n- [3.14.1](/python/docs/reference/bigquery/3.14.1/format_options)\n- [3.13.0](/python/docs/reference/bigquery/3.13.0/format_options)\n- [3.12.0](/python/docs/reference/bigquery/3.12.0/format_options)\n- [3.11.4](/python/docs/reference/bigquery/3.11.4/format_options)\n- [3.4.0](/python/docs/reference/bigquery/3.4.0/format_options)\n- [3.3.6](/python/docs/reference/bigquery/3.3.6/format_options)\n- [3.2.0](/python/docs/reference/bigquery/3.2.0/format_options)\n- [3.1.0](/python/docs/reference/bigquery/3.1.0/format_options)\n- [3.0.1](/python/docs/reference/bigquery/3.0.1/format_options)\n- [2.34.4](/python/docs/reference/bigquery/2.34.4/format_options)\n- [2.33.0](/python/docs/reference/bigquery/2.33.0/format_options)\n- [2.32.0](/python/docs/reference/bigquery/2.32.0/format_options)\n- [2.31.0](/python/docs/reference/bigquery/2.31.0/format_options)\n- [2.30.1](/python/docs/reference/bigquery/2.30.1/format_options)\n- [2.29.0](/python/docs/reference/bigquery/2.29.0/format_options)\n- [2.28.1](/python/docs/reference/bigquery/2.28.1/format_options)\n- [2.27.1](/python/docs/reference/bigquery/2.27.1/format_options)\n- [2.26.0](/python/docs/reference/bigquery/2.26.0/format_options)\n- [2.25.2](/python/docs/reference/bigquery/2.25.2/format_options)\n- [2.24.1](/python/docs/reference/bigquery/2.24.1/format_options)\n- [2.23.3](/python/docs/reference/bigquery/2.23.3/format_options)\n- [2.22.1](/python/docs/reference/bigquery/2.22.1/format_options)\n- [2.21.0](/python/docs/reference/bigquery/2.21.0/format_options)\n- [2.20.0](/python/docs/reference/bigquery/2.20.0/format_options)\n- [2.19.0](/python/docs/reference/bigquery/2.19.0/format_options)\n- [2.18.0](/python/docs/reference/bigquery/2.18.0/format_options)\n- [2.17.0](/python/docs/reference/bigquery/2.17.0/format_options)\n- [2.16.1](/python/docs/reference/bigquery/2.16.1/format_options)\n- [2.15.0](/python/docs/reference/bigquery/2.15.0/format_options)\n- [2.14.0](/python/docs/reference/bigquery/2.14.0/format_options)\n- [2.13.1](/python/docs/reference/bigquery/2.13.1/format_options)\n- [2.12.0](/python/docs/reference/bigquery/2.12.0/format_options)\n- [2.11.0](/python/docs/reference/bigquery/2.11.0/format_options)\n- [2.10.0](/python/docs/reference/bigquery/2.10.0/format_options)\n- [2.9.0](/python/docs/reference/bigquery/2.9.0/format_options)\n- [2.8.0](/python/docs/reference/bigquery/2.8.0/format_options)\n- [2.7.0](/python/docs/reference/bigquery/2.7.0/format_options)\n- [2.6.2](/python/docs/reference/bigquery/2.6.2/format_options)\n- [2.5.0](/python/docs/reference/bigquery/2.5.0/format_options)\n- [2.4.0](/python/docs/reference/bigquery/2.4.0/format_options)\n- [2.3.1](/python/docs/reference/bigquery/2.3.1/format_options)\n- [2.2.0](/python/docs/reference/bigquery/2.2.0/format_options)\n- [2.1.0](/python/docs/reference/bigquery/2.1.0/format_options)\n- [2.0.0](/python/docs/reference/bigquery/2.0.0/format_options)\n- [1.28.2](/python/docs/reference/bigquery/1.28.2/format_options)\n- [1.27.2](/python/docs/reference/bigquery/1.27.2/format_options)\n- [1.26.1](/python/docs/reference/bigquery/1.26.1/format_options)\n- [1.25.0](/python/docs/reference/bigquery/1.25.0/format_options)\n- [1.24.0](/python/docs/reference/bigquery/1.24.0/format_options)\n- [1.23.1](/python/docs/reference/bigquery/1.23.1/format_options)\n- [1.22.0](/python/docs/reference/bigquery/1.22.0/format_options)\n- [1.21.0](/python/docs/reference/bigquery/1.21.0/format_options)\n- [1.20.0](/python/docs/reference/bigquery/1.20.0/format_options)\n- [1.19.0](/python/docs/reference/bigquery/1.19.0/format_options)\n- [1.18.0](/python/docs/reference/bigquery/1.18.0/format_options)\n- [1.17.0](/python/docs/reference/bigquery/1.17.0/format_options)\n- [1.16.0](/python/docs/reference/bigquery/1.16.0/format_options) \n\nBigQuery Format Options\n=======================\n\n### *class* google.cloud.bigquery.format_options.AvroOptions()\n\nOptions if source format is set to AVRO.\n\n#### *classmethod* from_api_repr(resource: [Dict](https://docs.python.org/3/library/typing.html#typing.Dict)\\[[str](https://docs.python.org/3/library/stdtypes.html#str), [bool](https://docs.python.org/3/library/functions.html#bool)\\])\n\nFactory: construct an instance from a resource dict.\n\n- **Parameters**\n\n **resource** (*Dict* *\\[* [*str*](https://docs.python.org/3/library/stdtypes.html#str)*, \\*\\[* bool*\\](\u003chttps://docs.python.org/3/library/functions.html#bool\u003e)* \\]\\*) -- Definition of a `AvroOptions` instance in\n the same representation as is returned from the API.\n- **Returns**\n\n Configuration parsed from `resource`.\n- **Return type**\n\n `AvroOptions`\n\n#### to_api_repr()\n\nBuild an API representation of this object.\n\n- **Returns**\n\n A dictionary in the format used by the BigQuery API.\n- **Return type**\n\n Dict\\[[str](https://docs.python.org/3/library/stdtypes.html#str), [bool](https://docs.python.org/3/library/functions.html#bool)\\]\n\n#### *property* use_avro_logical_types(*: Optional\\[[bool](https://docs.python.org/3/library/functions.html#bool)* )\n\n\\[Optional\\] If sourceFormat is set to 'AVRO', indicates whether to\ninterpret logical types as the corresponding BigQuery data type (for\nexample, TIMESTAMP), instead of using the raw type (for example,\nINTEGER).\n\nSee\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#AvroOptions.FIELDS.use_avro_logical_types\u003e\n\n### *class* google.cloud.bigquery.format_options.ParquetOptions()\n\nAdditional options if the PARQUET source format is used.\n\n#### *property* enable_list_inference(*: \\[bool\\](\u003chttps://docs.python.org/3/library/functions.html#bool\u003e* )\n\nIndicates whether to use schema inference specifically for Parquet LIST\nlogical type.\n\nSee\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#ParquetOptions.FIELDS.enable_list_inference\u003e\n\n#### *property* enum_as_string(*: \\[bool\\](\u003chttps://docs.python.org/3/library/functions.html#bool\u003e* )\n\nIndicates whether to infer Parquet ENUM logical type as STRING instead of\nBYTES by default.\n\nSee\n\u003chttps://cloud.google.com/bigquery/docs/reference/rest/v2/tables#ParquetOptions.FIELDS.enum_as_string\u003e\n\n#### *classmethod* from_api_repr(resource: [Dict](https://docs.python.org/3/library/typing.html#typing.Dict)\\[[str](https://docs.python.org/3/library/stdtypes.html#str), [bool](https://docs.python.org/3/library/functions.html#bool)\\])\n\nFactory: construct an instance from a resource dict.\n\n- **Parameters**\n\n **resource** (*Dict* *\\[* [*str*](https://docs.python.org/3/library/stdtypes.html#str)*, \\*\\[* bool*\\](\u003chttps://docs.python.org/3/library/functions.html#bool\u003e)* \\]\\*) -- Definition of a `ParquetOptions` instance in\n the same representation as is returned from the API.\n- **Returns**\n\n Configuration parsed from `resource`.\n- **Return type**\n\n `ParquetOptions`\n\n#### *property* map_target_type(*: Optional\\[Union\\[[bool](https://docs.python.org/3/library/functions.html#bool), [str](https://docs.python.org/3/library/stdtypes.html#str)\\]* )\n\nIndicates whether to simplify the representation of parquet maps to only show keys and values.\n\n#### to_api_repr()\n\nBuild an API representation of this object.\n\n- **Returns**\n\n A dictionary in the format used by the BigQuery API.\n- **Return type**\n\n Dict\\[[str](https://docs.python.org/3/library/stdtypes.html#str), [bool](https://docs.python.org/3/library/functions.html#bool)\\]"]]