SFDMU Help CenterAre the field names and the object name used in the object's SOQL query case sensitive?
Answer.
The fields names used in an object's SOQL select statements are case insensitive. So the query: "SELECT id, NAme FROM Account" should be correct as well.
The object names used in a SOQL are case sensitive. So the query: "SELECT id, Name FROM ACCOUNT" should not be handled correctly.
Despite this, there are several exceptions when case of SOQL fields is important:
- For the Fields Mapping and Data Anonymization, you need to specify fields and object names exactly, because they are case sensitive.
- When listing sObject field(s) in an externalId setting, it is crucial to ensure that the fields are spelled correctly, as this setting is case-sensitive.