Share via

Salesforce connector reference

  • Article

Important

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