Data Type Mapping | BigQuery Connector | QueryGrid - BigQuery Data Type Mapping - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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.