Salesforce ingestion connector reference

This page contains reference material for the Salesforce ingestion connector in Databricks Lakeflow Connect.

Automatic data transformations

Databricks transforms Salesforce data types to Delta-compatible data types as follows:

Salesforce type	Delta type
Auto Number	String
Checkbox	Boolean
Currency	DecimalType(38, scale), where scale is min(source-scale + (38 - source-precision), 24)
Date	DateType
Time	String
DateTime	Timestamp
Email	String
ID	String
Lookup Relationship	String
Multi-Select Picklist	String (for a picklist with the selected values USD and Euro, the column contains USD;Euro)
Number	Double
Percent	Double
Phone	String
Picklist	String
Text	String
Text Area	String
Text Area (Long)	String
Text Area (Rich)	String
Text (Encrypted)	String
URL	String

Salesforce type	Delta type
Auto Number	String
Checkbox	Boolean
Currency	DecimalType(38, scale), where scale is min(source-scale + (38 - source-precision), 24)
Date	DateType
Time	String
DateTime	Timestamp
Email	String
ID	String
Lookup Relationship	String
Multi-Select Picklist	String (for a picklist with the selected values USD and Euro, the column contains USD;Euro)
Number	Double
Percent	Double
Phone	String
Picklist	String
Text	String
Text Area	String
Text Area (Long)	String
Text Area (Rich)	String
Text (Encrypted)	String
URL	String

note

The Salesforce API returns three fields as double instead of int: Site.DailyBandwidthUsed, Site.DailyRequestTimeUsed, and Knowledge__kav.Attachment__Length__s. Databricks ingests each as Double.

Compound fields

Salesforce compound field types (address and location) aren't ingested as a single column. Instead, Databricks ingests the individual component fields that make up each compound field as separate columns.

For example:

• For an address compound field (for example, BillingAddress), Databricks ingests its component fields as separate columns, such as BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, BillingLatitude, and BillingLongitude.
• For a location (geolocation) compound field, Databricks ingests its components: latitude and longitude.

Incremental formula field ingestion

Unsupported formula functions result in NULL values. For a list of unsupported functions, see Limitations.