Google BigQuery Connectors > Part II: Data Integration with Google BigQuery V2 Connector > Data type reference > Google BigQuery V2 and transformation data types
  

Google BigQuery V2 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
Boolean True or False values.
Default precision is 5.
BIGNUMERIC
String
1 to 104,857,60 characters
Default precision is 255. You can increase the value up to 10485760 characters.
DATE¹
Date/Time
Date values. Google BigQuery Connector uses the following format:
YYYY-[M]M-[D]D
Minimum value: 0001-01-01
Maximum value: 9999-12-31
Precision 29, scale 9
DATETIME¹
Date/Time
Google BigQuery Connector uses the following format:
YYYY-[M]M-[D]D[( |T)[H]H:[M]M:[S]S[.DDDDDD]]
Minimum value: 0001-01-01 00:00:00
Maximum value: 9999-12-31 23:59:59.999999
Default precision 29, scale 9
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
-9.9999999999999999999999999999999999999E+29 to 9.9999999999999999999999999999999999999+29
Default precision 28, scale 10
Maximum precision of 29.
Note: Though the Fields tab shows the scale as 10, Google BigQuery supports scale upto 9.
STRING
String
1 to 104,857,60 characters
Default precision is 255. You can increase the value up to 10485760 characters.
BYTE
Bytes
1 to 104,857,60 bytes
TIME¹
Date/Time
Time values. Google BigQuery Connector uses the following format:
[H]H:[M]M:[S]S[.DDDDDD]
Minimum value: 00:00:00
Maximum value: 23:59:59.999999
Precision 29, scale 9
TIMESTAMP¹
Date/Time
Google BigQuery Connector uses the following format:
YYYY-[M]M-[D]D[( |T)[H]H:[M]M:[S]S[.DDDDDD]][time zone]
Minimum value: 0001-01-01 00:00:00
Maximum value: 9999-12-31 23:59:59.999999 UTC
Precision 29, scale 9
INT64²
BigInt
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
FLOAT64²
Double
Precision 15, scale 0
BOOL²
String
Boolean True or False values.
Default precision is 5.
¹where
  • - YYYY represents four-digit year
  • - [M]M represents one or two digit month
  • - [D]D represents one or two digit day
  • - ( |T) represents a space or a T separator
  • - [H]H represents one or two digit hour (valid values from 00 to 23)
  • - [M]M represents one or two digit minutes (valid values from 00 to 59)
  • - [S]S represents one or two digit seconds (valid values from 00 to 59)
  • - [.DDDDDD]: represents microseconds upto six fractional digits.
  • - [time zone] represents the time zone. Default time zone is UTC.
²Applies only to SQL transformation.