Salesforce to Google BigQuery mapping

AutoSync maps Salesforce object types to the following BigQuery column types:


Salesforce object type	Google BigQuery column type
`base64`	`STRING`
`boolean`	`BOOL`
`byte`	`INT64`
`date`	`DATE`
`datetime`	`TIMESTAMP`
`decimal`	`NUMERIC`
`double`	`NUMERIC`
`int`	`INT64`
`long`	`INT64`
`string`	`STRING`
`time`	`TIME`
`sl_timestamp`	`TIMESTAMP`
`address`	`JSON`
`anyType`	`STRING`
`calculated`	`STRING`
`combobox`	`STRING`
`currency`	`NUMERIC`
`datacategorygroupreference`	`STRING`
`email`	`STRING`
`encryptedstring`	`STRING`
`id`	`STRING`
`junctionidlist`	`STRING`
`location`	`STRING`
`masterrecord`	`STRING`
`multipicklist`	`STRING`
`percent`	`NUMERIC`
`phone`	`STRING`
`picklist`	`STRING`
`reference`	`STRING`
`textarea`	`STRING`
`url`	`STRING`
`complexvalue`	`STRING`
`json`	`JSON`