Salesforce Marketing Cloud connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page provides technical reference information for the Salesforce Marketing Cloud connector.

Supported objects

The Salesforce Marketing Cloud connector supports the following default tables (when source_schema is set to default):

Table name	Update type
journeys	Incremental
campaigns	Incremental
emails	Incremental
automations	Batch (non-incremental)
push_messages	Incremental
subscribers	Batch (non-incremental)
audit_events	Incremental
security_events	Incremental
click_events	Incremental
sent_events	Incremental
open_events	Incremental
not_sent_events	Incremental
bounce_events	Incremental
unsubscribe_events	Incremental

For data extensions, you must provide the External Key (Customer Key) as the source_table name. Data extensions are batch-only (non-incremental).

Automatic data type transformations

The connector transforms Salesforce Marketing Cloud data types in data extensions to Delta-compatible data types as follows:

Salesforce Marketing Cloud type	Delta type
Text	string
Email	string
EmailAddress	string
Phone	string
Locale	string
Number	integer
LongNumber	long
Decimal(p, s)	decimal(min(p, 38), min(s, 18))
Boolean	boolean
Date	timestamp_ntz
Byte	byte

note

The Marketing Cloud APIs don't provide information about the timezone of timestamps. Therefore, the connector stores timestamps with no time zone (TimestampNTZ).

Required authentication fields

When you create a Unity Catalog connection for Salesforce Marketing Cloud, provide the following parameters:

Field	Description
Subdomain	The 28-character subdomain for your Marketing Cloud instance, starting with mc from the Authentication Base URI (for example, mc1234abcdzz9t0k5l7m8n9p0q)
Marketing ID (MID)	The Marketing ID for your business account, visible in the top right corner of the Salesforce Marketing Cloud interface
Client ID	The client ID from the API Integration Package
Client Secret	The client Secret from the API Integration Package

Schemas for default tables

For detailed schemas of all supported default tables (including field names and data types), see the following sections:

journeys

Composite primary key: (id, version).

Field	Data type
id	string
version	integer
key	string
name	string
lastPublishedDate	timestamp
status	string
description	string
createdDate	timestamp
modifiedDate	timestamp
workflowApiVersion	integer
activities	array<struct>
triggers	array<struct>
goals	array<string>
exits	array<string>
notifiers	array<string>
stats	struct
healthStatus	struct
entryMode	string
definitionType	string
channel	string
defaults	struct
metaData	string
executionMode	string
categoryId	integer
definitionId	string
scheduledStatus	string
campaigns	array<string>

campaigns

Field	Data type
id	string
createdDate	timestamp
modifiedDate	timestamp
name	string
description	string
campaignCode	string
color	string
favorite	boolean

emails

Field	Data type
id	long
customerKey	string
objectID	string
contentType	string
assetTypeId	integer
assetTypeName	string
assetTypeDisplayName	string
name	string
owner	struct
createdBy	struct
createdDate	timestamp
modifiedBy	struct
modifiedDate	timestamp
enterpriseId	long
status	string
thumbnailUrl	string
content	string
preheaderViewContent	string
subjectlineViewContent	string
htmlViewContent	string
characterEncoding	string

automations

Composite primary key: (id, view).

The view column is a synthetic column added by the connector. It distinguishes between record types within the same automation entry (normal vs. targetdes).

Field	Data type
id	string
view	string
key	string
name	string
description	string
categoryId	integer
type	string
typeId	integer
status	string
statusId	integer
schedule	struct<typeId: integer, startDate: timestamp_ntz, endDate: timestamp_ntz, scheduledTime: timestamp_ntz>
lastRunTime	timestamp_ntz
lastRunInstanceId	string
automationTrigger	struct
fileTrigger	struct
targetDataExtensions	array<struct>

Event tables

All event tables (click_events, sent_events, open_events, bounce_events, unsubscribe_events, not_sent_events) share similar schemas with fields including:

• BatchID (integer)
• EventDate (timestamp)
• SendID (integer)
• SubscriberKey (string)
• TriggeredSendDefinitionObjectID (string)

Additional fields vary by event type. For complete schemas, refer to the Salesforce Marketing Cloud API documentation.