Salesforce to Azure Synapse mapping

AutoSync maps Salesforce object types to the following Azure Synapse column types:


Salesforce object type	Azure Synapse column type
`base64`	`varchar`
`boolean`	`bit`
`byte`	`bigint`
`date`	`date`
`datetime`	`datetimeoffset`
`decimal`	`decimal`
`double`	`decimal`
`int`	`int`
`long`	`bigint`
`string`	`varchar`
`time`	`time`
`address`	`varchar`
`anyType`	`varchar`
`calculated`	`varchar`
`combobox`	`varchar`
`currency`	`decimal`
`datacategorygroupreference`	`varchar`
`email`	`varchar`
`encryptedstring`	`varchar`
`id`	`varchar`
`junctionidlist`	`varchar`
`location`	`varchar`
`masterrecord`	`varchar`
`multipicklist`	`varchar`
`percent`	`decimal`
`phone`	`varchar`
`picklist`	`varchar`
`reference`	`varchar`
`textarea`	`varchar`
`url`	`varchar`
`complexvalue`	`varchar`
`json`	`varchar`