Salesforce to Snowflake mapping
AutoSync maps Salesforce object types to the following Snowflake column types:
Salesforce object type | Snowflake column type |
---|---|
base64 |
varchar |
boolean |
boolean |
byte |
number |
date |
date |
datetime |
timestamp_tz |
decimal |
number |
double |
number |
int |
number |
long |
number |
string |
varchar |
time |
time |
sl_timestamp |
timestamp_tz |
address |
object |
anyType |
varchar |
calculated |
varchar |
combobox |
varchar |
currency |
number |
datacategorygroupreference |
varchar |
email |
varchar |
encryptedstring |
varchar |
id |
varchar |
junctionidlist |
varchar |
location |
varchar |
masterrecord |
varchar |
multipicklist |
varchar |
percent |
number |
phone |
varchar |
picklist |
varchar |
reference |
varchar |
textarea |
varchar |
url |
varchar |
complexvalue |
varchar |
json |
object |