The Personalization Data Warehouse supports the use of "scratch" tables for analysis, reporting, or investigation. In addition, scratch tables can be used as a data source by the Personalization ETL system. Using the ETL system and scratch tables, data scientists can load machine learning model scoring outputs from their data science workbench back into the Personalization production database to enrich user profile attributes. Customers can add and drop scratch tables in their data warehouse that follow the scratch schema specifications described in this article.
The Data Warehouse is available only to customers who have already purchased the Marketing Cloud Personalization - Data Warehouse add-on product.
The Data Warehouse scratch tables temporarily store Data Science workbench model score outputs for loading back into Personalization user profile attributes. Personalization Data Warehouse supports the ingestion of data written to customer's scratch schema. Tables in the scratch schema can be treated as data sources for the Personalization ETL system.
Multi-channel operation is enabled when user identities can be matched with the Personalization identity resolution system. Catalog data best support multi-channel operation when identities for online and offline product and dimension identities match.
Table Name Format:
retail_user_20200101_093000. Optionally, you can include a descriptive token in the name:
You must supply some form of user id, so at least one of the following optional user or email address fields is required to process a row.
To be able to process updates, include a
created_ts field, as shown in the following table. This way, the ETL can process rows created since the last run. Instead of updating attributes in a scratch table, use a
DELETE and an
INSERT so that the
created_ts field is reset, or include the
created_ts in your
|Field Name||Minimum Requirements||Example Values||Data Type|
|Optional. Must match the format of the configured default user ID type for this feed. Since a user can have multiple identities, user ids can also be constructed from other identifying information in the record (||VARCHAR(120)|
|Optional. Column titles are the token ||VARCHAR(120)|
|Optional. If provided, a string value of the account ID to associate with the user. Must be lowercase. This field is only available with Personalization B2B functionality enabled. Contact your customer success representative for details.||example industries, example.com||VARCHAR(120)|
|Optional. Display name for user.||Bob Newhart||VARCHAR(1023)|
|Optional. Valid email address. If provided, used as a user identity of the type ||email@example.com, firstname.lastname@example.org||VARCHAR(1023)|
|Optional. The custom attributes for this user. Column titles are the word ||VARCHAR(1023)|
|Required. Records when the row was created.||TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT |