Salesforce to Snowflake data type mapping is important to ensure you map the right data from Salesforce into the correct column data type. Common data types include INT for integers, VARCHAR for variable-length strings, DATE for dates, etc. When Snowflake loads data using the import from data option, it infers the data type of each column based on the data. Typically when working with your ETL and data team, it is vital to provide data types and proper mapping. The following is a mapping table.
| Salesforce Data Type | Snowflake Data Type | Notes |
| address | OBJECT or VARIANT | May require a custom structure or JSON format |
| anyType | VARIANT | VARIANT can store various types |
| calculated | Dependent on formula | Maps based on the underlying data type |
| combobox | VARCHAR | |
| currency | NUMBER or FLOAT | |
| DataCategoryGroupReference | VARCHAR | |
| VARCHAR | ||
| encryptedstring | BINARY or VARCHAR | Depending on encryption handling |
| ID | VARCHAR | ID is typically a string in Salesforce |
| JunctionIdList | ARRAY | If representing as an array |
| location | GEOGRAPHY or OBJECT | For geospatial data types |
| masterrecord | VARCHAR | |
| multipicklist | ARRAY or VARCHAR | Represented as an array or comma-separated values |
| percent | FLOAT | |
| phone | VARCHAR | |
| picklist | VARCHAR | |
| reference | VARCHAR | Reference fields are often IDs or strings |
| textarea | TEXT or VARCHAR | TEXT in Snowflake for longer text |
| url | VARCHAR |
