Google BigQuery Connectors > Part III: Data Integration with Google BigQuery Connector > Data Type Reference > Google BigQuery and transformation data types
  

Google BigQuery and transformation data types

The following table describes the data types that Data Integration supports for Google BigQuery sources and targets:
Google BigQuery Data Type
Transformation Data Type
Range and Description for the Transformation Data Type
BOOLEAN
String
1 to 104,857,600 characters.
Boolean True or False values.
Default precision is 5.
DATE
Date/Time
Date values. Google BigQuery Connector uses the following format:
DD-MM-YYYY
Minimum value: 1/1/1970
Maximum value: 30/12/9999
Precision 29, scale 9
DATETIME
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Default precision 29, scale 9
Note: Google BigQuery Connector supports YYYY format for the year.
FLOAT
Double
Precision 15, scale 0
INTEGER
BigInt
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
RECORD
String
1 to 104,857,600 characters
Default precision is 255. You can increase the value up to 104857600 characters.
NUMERIC
Decimal
Default precision 28, scale 10
Note: Though the Fields tab shows the scale as 10, Google BigQuery supports scale upto 9.
STRING
String
1 to 104,857,600 characters
Default precision is 255. You can increase the value up to 104857600 characters.
BYTE
Byte
1 to 104,857,600 bytes
TIME
Date/Time
Time values.
(precision to the nanosecond)
Precision 29, scale 9
TIMESTAMP
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Precision 29, scale 9
Note: Google BigQuery Connector supports YYYY format for the year.
Note: When you run a mapping to read data of timestamp data type from a Google BigQuery source object, incorrect values are written to the target for certain timestamp values. Few milliseconds differences is observed.