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:
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.