Salesforce to Redshift mapping
AutoSync maps Salesforce object types to the following Redshift column types:
Salesforce object type | Redshift column type |
---|---|
base64 |
varchar |
boolean |
boolean |
byte |
bigint |
date |
date |
datetime |
timestamptz |
decimal |
decimal |
double |
decimal |
int |
integer |
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 |