Data type conversions from BigQuery to DataStage

When reading data, the BigQuery connector stage converts BigQuery data types to InfoSphere® DataStage® data types.

Usage

When the metadata is imported through the BigQuery connector, the BigQuery data types are converted to IBM® InfoSphere DataStage data types. The following table shows the mapping rules between BigQuery data types and InfoSphere DataStage data types:
Table 1. BigQuery data types and their equivalent InfoSphere DataStage data types
BigQuery data types InfoSphere DataStage data types
STRING LongNVarChar
BOOLEAN Bit
BYTES LongVarBinary
DATE Date
DATETIME TimeStamp
FLOAT Double
INTEGER BigInt
Numeric Decimal
TIME Time
Note: BigQuery supports two datatypes related to timestamp: DATETIME and TIMESTAMP. While DATETIME is supported on BigQuery Connector, TIMESTAMP, which contains the timezone is not supported by the connector.