When you import data from Google BigQuery, Google BigQuery data types are mapped to Anaplan Data Orchestrator (ADO) data types.

This table displays the data mapping between BigQuery and ADO data types.

Google BigQuery data typesADO data types
BOOLBoolean
INT64Integer
FLOAT64String
NUMERICString
BIGNUMERICString
STRINGString
BYTESString
DATEString
DATETIMEString
TIMESTAMPString
TIMEString
ARRAYString
STRUCTString
GEOGRAPHYString