SFDMU Help CenterAre field names and object names in a SOQL query case sensitive?
Answer.
- The field names used in SOQL select statements are case-insensitive. Therefore, the query "SELECT id, NAme FROM Account" is valid.
- The object names used in SOQL are also generally case-insensitive. Therefore, "SELECT id, Name FROM ACCOUNT" is handled correctly.
However, there are SFDMU configuration areas where exact field/object spelling still matters:
- For Fields Mapping and Data Anonymization, specify field and object API names exactly as expected by the mapping/transformation logic.
- When listing sObject field(s) in an externalId setting, ensure fields are spelled correctly.