DataExtension

Represents a data extension within an account.

Table-Specific Information

Select

The 本製品 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 本製品 processes other filters client-side within the 本製品.

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

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

Insert

You must specify the following fields when inserting to this table: Name, CustomerKey, and Fields.

Note: The Salesforce Marketing Cloud APIs have problems with DataExtensions with names longer than 40 characters. Try to limit the name to something relatively short.

INSERT INTO DataExtension (Name, CustomerKey, Fields) VALUES ('TestName', 'TestCustomerKey', 'fieldname1;fieldname2;fieldname3')

Update

You must specify the ObjectId or CustomerKey or Name in the WHERE clause when executing an update against this table.

UPDATE DataExtension SET ResetRetentionPeriodOnImport = true WHERE ObjectId = 'nzxcaslkjd-123'

Delete

You must specify the ObjectId or CustomerKey or Name in the WHERE clause when executing a delete against this table.

DELETE FROM DataExtension WHERE ObjectId = 'nzxcaslkjd-123'

Columns


Name	Type	ReadOnly	Description
ObjectID [KEY]	String	False	System-controlled, text string identifier for object.
PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
Name	String	False	Name of the object or property.
CreatedDate	Datetime	False	Date and time of the object's creation.
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
Client_ID	Int	False	The Id of the client.
Description	String	False	Describes and provides information regarding the object.
IsSendable	Bool	False	Indicates whether you can use a data extension as part of an audience for a message send.
IsTestable	Bool	False	Indicates whether a sendable data extension can be used within tests sends for a message.
SendableDataExtensionField_Name	String	False	The name of the sendable data extension field.
SendableSubscriberField_Name	String	False	The name of the sendablesubscriber field.
Template_CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
CategoryID	Long	False	Specifies the identifier of the folder.
Status	String	False	Defines status of the object.
IsPlatformObject	Bool	False	Indicated whether the object is a platform object.
DataRetentionPeriodLength	Int	False	Specifies the number of time units for which data will be retained.
DataRetentionPeriodUnitOfMeasure	Int	False	Specifies the units of time for which data will be retained.
RowBasedRetention	Bool	False	Indicates whether the data retention policy removes data by row or by entire data extension.
ResetRetentionPeriodOnImport	Bool	False	Indicates whether a data retention period should be reset after a successful import of new data.
DeleteAtEndOfRetentionPeriod	Bool	False	Indicates whether data should be deleted at the end of the retention period.
RetainUntil	String	False	Indicates the date that ends the retention period for a data extension.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Fields	String	A semi-colon separated list of names for the fields to add to this data entension.

JDBC Driver for Salesforce Marketing Cloud