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
Email	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 and Site.DailyRequestTimeUsed as float instead of int.

Unsupported objects

The following objects are not supported:

• Objects that have a WHERE clause or LIMIT 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