Global Types to BigQuery Data Types
The initiator connector maps global data types to BigQuery data types.
Global Type | BigQuery Type |
---|---|
G_Array/G_Array_VC/G_Array_VC_Latin/G_Array_VC_UTF16 | Array |
G_Boolean | Boolean |
G_Blob/G_Byte/G_Varbyte | Bytes |
G_Date | Date |
G_TimeStamp | DateTime |
G_Double/G_Float | Float64 |
G_BigInt/G_ByteInt/G_Integer/G_SmallInt | Int64 |
G_Decimal/G_Number | Numeric/BigNumeric When inserting into BigQuery decimal, if value is too large, an error occurs. If there are too many digits after the decimal point, the number is rounded up.
|
G_Char_Latin/G_Char_UTF16/G_Char_UTF8 | String |
G_Clob/G_Clob_Latin/G_Clob_UTF16/G_Clob_UTF8 | String |
All interval types | String |
G_JSON/G_JSON_Latin/G_JSON_UTF16 | String |
G_LongVarchar/G_Map | String |
G_STGeometry | String |
G_Varchar_Latin/G_Varchar_UTF16/G_Varchar_UTF8/G_XML | String |
G_Row | Struct |
G_Time | Time |
G_TimeStampWithTimeZone | Timestamp |
BigQuery Data Types to Global Types
The target connector maps BigQuery data types to global data types.
BigQuery Type | Global Type |
---|---|
Array | G_Array |
Boolean | G_Boolean |
Bytes | G_Blob/G_VarByte G_VarByte mapped when 16.20+ LOB Support in the connector properties is not selected.
|
Date | G_Date |
Datetime | G_TimeStamp |
Geography | G_Clob_UTF16 |
INT64 (INT, SMALLINT, INTEGER, BIGINT, TINYINT, and BYTEINT) | G_BigInt |
Numeric (Decimal) | G_Decimal |
BigNumeric (BigDecimal) | G_BigDecimal When the BigNumeric type contains more than 38 digits, it can be imported as long as the integer part has less than 30 digits. Any fractional parts are truncated (rounded). Fractional parts with 9 digits are supported for both Numeric and BigNumeric.
|
Float64 | G_Double |
String | G_Clob_UTF16/G_VarChar G_VarChar mapped when 16.20+ LOB Support in the connector properties is not selected.
|
Struct | G_Row |
Time | G_VarChar |
TimeStamp | G_TimeStampWithTimeZone |
BigQuery VarChar and Binary Type Considerations
BigQuery connector BLOB and CLOB columns are restricted to a maximum of 100MB in size. Due to the in-memory nature of these types, a large amount of resources are required on the BigQuery side when their sizes near 100MB. Teradata recommends increasing the BigQuery connector driver heap size when working with CLOB or BLOB types.