Subscriber

Represents a subscriber in Salesforce Marketing Cloud. Each record identifies an individual who has opted to receive marketing communications via email or Short Message Service (SMS). This table is central to subscriber management, preference handling, and audience segmentation.

Table-Specific Information

Select

The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.

For example, the following (but not only) queries are processed server side:

SELECT * FROM Subscriber WHERE Id = 123

SELECT * FROM Subscriber WHERE Id IN (123, 456)

SELECT * FROM Subscriber WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: SubscriberKey and EmailAddress.

INSERT INTO Subscriber (SubscriberKey, EmailAddress) VALUES (123, '[email protected]')

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Subscriber SET EmailAddress = '[email protected]' WHERE Id = 123

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Subscriber WHERE Id = 123

Columns


Name	Type	ReadOnly	Description
ID	Int	False	Specifies the unique identifier (Id) for the subscriber record. This Id distinguishes the subscriber from all other subscriber records within the system.
PartnerKey	String	False	Specifies the unique Id that is provided by a partner system for the subscriber. This partner-supplied value enables cross-system correlation and is accessible only through the API.
CreatedDate	Datetime	False	Indicates the date and time when the subscriber record was created. This timestamp is generated automatically and provides an audit reference for record lifecycle tracking.
Client_ID	Int	False	Specifies the Id of the client that owns the subscriber record. This Id establishes the account context in which the subscriber exists.
Client_PartnerClientKey	String	False	Specifies the user-defined partner key for the client that is associated with the subscriber. This key provides an additional mapping reference for external integrations.
EmailAddress	String	False	Specifies the email address that is associated with the subscriber. This value determines the address used for email sends and subscriber-level communication.
SubscriberKey	String	False	Specifies the unique key that identifies a subscriber across all lists, data extensions, and channels. This key is typically user-defined and ensures consistent subscriber recognition throughout the system.
UnsubscribedDate	Datetime	False	Indicates the date and time when the subscriber unsubscribed from a list or communication stream. This timestamp reflects the moment the subscriber opted out of receiving further messages.
Status	String	False	Defines the current status of the subscriber. This status reflects whether the subscriber is active, bounced, held, unsubscribed, or otherwise restricted from receiving messages.
EmailTypePreference	String	False	Specifies the preferred email format for the subscriber. This value determines whether the subscriber receives messages in HTML, text-only, or multipart format based on their stated preference.