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