DataExtensionTemplate
Represents data extension templates in Salesforce Marketing Cloud. A template defines the structural blueprint that can be reused to create multiple data extensions with consistent schema design. This view allows administrators to standardize data collection and storage across campaigns.
View-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 DataExtensionTemplate WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled identifier (Id) that uniquely identifies the data extension template object. This value is assigned internally and cannot be modified by users. |
| PartnerKey | String | Specifies the unique partner-provided key that is associated with the data extension template. This value is accessible only through the API. |
| CustomerKey | String | Specifies the user-supplied unique Id that identifies the data extension template within its object type. This value corresponds to the external key displayed in the user interface. |
| Name | String | Specifies the name of the data extension template. The name is used to identify the template in the user interface and during configuration. |
| CreatedDate | Datetime | Indicates the date and time when the data extension template was created. This value is read-only and maintained by the system. |
| ModifiedDate | Datetime | Indicates the date and time when the data extension template was last modified. This information supports auditing, change control, and lifecycle tracking. |
| Client_ID | Int | Specifies the Id of the client that is associated with the data extension template. |
| Description | String | Provides a human-readable explanation of the data extension template. This description helps users understand the template's purpose, usage, and behavior. |
| IsSendable | Bool | Returns a value of 'true' when the data extension template supports message sending operations in Salesforce Marketing Cloud. It returns a value of 'false' when the data extension template cannot be used as a sendable data source. |
| IsTestable | Bool | Returns a value of 'true' when the data extension template can be used in message test sends. It returns a value of 'false' when the data extension template cannot participate in test send workflows. |
| SendableCustomObjectField | String | Specifies the name of the field within the template that represents the sendable custom object field. This field must align with the subscriber Id that is used for message sends. |
| SendableSubscriberField | String | Specifies the name of the field within the template that identifies the subscriber to whom messages are sent. This field corresponds to either the subscriber key or the email address. |
| DataRetentionPeriodLength | String | Specifies the numeric duration of the data retention period that applies to the data extension template. This value defines how long data remains available before retention policies take effect. |
| DataRetentionPeriodUnitOfMeasure | Int | Specifies the unit of time that is associated with the data retention period (for example, days, weeks, or months). This unit works together with the DataRetentionPeriodLength value to determine total retention duration. |
| RowBasedRetention | Bool | Returns a value of 'true' when the system removes data based on the age of individual rows rather than the entire data set. It returns a value of 'false' when retention applies to the entire data extension as a whole. |
| ResetRetentionPeriodOnImport | Bool | Returns a value of 'true' when the system resets the retention period each time new data is imported into the data extension. It returns a value of 'false' when retention timelines continue uninterrupted regardless of imports. |
| DeleteAtEndOfRetentionPeriod | Bool | Returns a value of 'true' when the system deletes data automatically upon the completion of the configured retention period. It returns a value of 'false' when the system retains the data beyond the specified retention duration. |
| RetainUntil | Datetime | Specifies the calendar date and time until which the data will be retained under the active retention policy. This value determines when the final retention threshold is reached. |