The following table lists the Google Cloud Storage data types based on the file format type that can be pushed to the Google BigQuery database:

File format type	Google Cloud Storage data type
Delimited	BigInt, Number, String
Avro	Binary, Byte, Double, Float, Int, Long, String
Parquet	Binary, Date, Decimal, Double, Float, Int32, Int64, Int96, String
JSON	Double, Int, Long, String

The following table lists the Google BigQuery native data types that can be mapped to the comparable transformation data types in a mapping configured with

SQL ELT optimization

:

Google BigQuery data type	Transformation data type
Boolean	String
Date	Date/Time
DateTime	Date/Time
Float	Double
Integer	BigInt
Numeric	Decimal Default precision 28, scale 9.
String	String
Byte	Byte
Time	Date/Time
Timestamp	Date/Time

When you set the custom property

OptimizeCastsInPDO:true

in Google BigQuery V2 connection optional properties, you can map the following date time data types in Google BigQuery source to a target in a mapping enabled with

SQL ELT optimization

:

Source data type	Supported target data type
Date	Date, Date/Time
Time	Time
Date/Time	Date, Time, Date/Time
Timestamp	Time, Timestamp