Google BigQuery Connectors

Back Next

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 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 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 Google BigQuery Connector supports YYYY format for the year.

When you write data of the Timestamp data type from a Google BigQuery source object, certain Timestamp values written to the target show a difference by a few milliseconds from the value in the source.

Rename Saved Search

Table of Contents

Google BigQuery Connectors

Google BigQuery Connectors

Google BigQuery and transformation data types

Google BigQuery and transformation data types