Salesforce ingestion connector reference
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 |
* Site.DailyBandwidthUsed (Int) | Float |
* Site.DailyRequestTimeUsed (Int) | Float |
- The Salesforce API returns
Site.DailyBandwidthUsed
andSite.DailyRequestTimeUsed
asfloat
instead ofint
.
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