Why Do Salesforce Field Labels Differ From Destination Column Names?

Question

Why are column names in the destination table different from what I see in the Salesforce dashboard?

Environment

Connector: Salesforce

Answer

The column names in your destination table don’t always match the display labels you see in the Salesforce UI. This is expected.

Salesforce fields have two attributes:

• Label: The display name you see in the Salesforce UI.
• API name: The internal field name used in the Salesforce API.

We use the API name as the column name in your destination. If the label and API name differ, you see the API name in your destination.

For additional information, see our table and column naming rules for non-database connectors.