Skip to main content

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 TypeDelta Type
Auto NumberString
CheckboxBoolean
CurrencyDecimalType(18,2)
DateDateType
TimeString
DateTimeTimestamp
EmailString
IDString
Lookup RelationshipString
Multi-Select PicklistString (For a currency picklist with the values “USD” and “Euro,” the column would include the values “USD” and “Euro.” )
NumberDecimal
PercentDouble
PhoneString
PicklistString
TextString
Text AreaString
Text Area (Long)String
Text Area (Rich)String
Text (Encrypted)String
URLString

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