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
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

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