Adapter Online Help > TDV Google BigQuery Adapter > Data Model > Data Type Mapping
 
Data Type Mapping
Data Type Mappings
The adapter maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
It should be noted that the NUMERIC type in Google BigQuery supports 38 digits of precision, while BigDecimal can only hold 29 digits of precision. As a result, data needing between 30-38 digits of precision must be cast as a string.
 
Google BigQuery
CData Schema
STRING
string
BYTES
binary
INTEGER
long
FLOAT
float
NUMERIC
decimal
BOOLEAN
bool
TIMESTAMP
datetime
DATE
date
TIME
time
DATETIME
datetime
RECORD
All items within the Record are exposed as seperate fields with their own typing.
GEOGRAPHY
string