Salesforce connector reference
Preview
LakeFlow Connect is in gated Public Preview. To participate in the preview, contact your Databricks account team.
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(18,2) |
Date |
DateType |
Time |
String |
DateTime |
Timestamp |
String |
|
ID |
String |
Lookup Relationship |
String |
Multi-Select Picklist |
String (For a currency picklist with the values “USD” and “Euro,” the column would include the values “USD” and “Euro.” ) |
Number |
Decimal |
Percent |
Double |
Phone |
String |
Picklist |
String |
Text |
String |
Text Area |
String |
Text Area (Long) |
String |
Text Area (Rich) |
String |
Text (Encrypted) |
String |
URL |
String |
Unsupported objects
The following objects are not supported:
Objects that have a
WHERE
clause orLIMIT
restrictions:Announcement
AppTabMember
CollaborationGroupRecord
ColorDefinition
ContentDocumentLink
ContentFolderItem
ContentFolderMember
DataStatistics
DatacloudDandBCompany
EntityParticle
FieldDefinition
FieldHistoryArchive
FlexQueueItem
FlowVariableView
FlowVersionView
IconDefinition
IdeaComment
NetworkUserHistoryRecent
OwnerChangeOptionInfo
PicklistValueInfo
PlatformAction
RelationshipDomain
RelationshipInfo
SearchLayout
SiteDetail
UserEntityAccess
UserFieldAccess
Vote
Objects for real-time event monitoring:
ApiEvent
BulkApiResultEventStore
EmbeddedServiceDetail
EmbeddedServiceLabel
FormulaFunction
FormulaFunctionAllowedType
FormulaFunctionCategory
IdentityProviderEventStore
IdentityVerificationEvent
LightningUriEvent
ListViewEvent
LoginAsEvent
LoginEvent
LogoutEvent
Publisher
RecordActionHistory
ReportEvent
TabDefinition
UriEvent
Objects ending with
__b
,__x
, or__hd
Other:
ActivityMetric
ActivityMetricRollup
Site