Would it be correct to think of an XDM schema as basically the same thing as a schema in Snowflake? And that XDM is just a data mart for platform? I'm in the process of mapping data from Snowflake into AEP for use with RT-CDP and need to ensure data is mapped correctly to support real- time personalization.
Hi @lkinoshita ,
No, an XDM schema is not the same thing as a Snowflake schema. While both are called "schemas," they serve fundamentally different purposes. Thinking of XDM as "just a data mart" is an oversimplification that can lead to incorrect data mapping.
Think of it this way:
You are not moving data from one database to another. You are translating data from an analytical storage format into an experience activation format.
Your Snowflake tables are likely structured for efficient reporting. XDM is structured for real-time decisioning.
Follow these steps:
1. Choose the Right XDM Class:
- Use XDM Individual Profile for "who the customer is" (e.g., customer attributes like loyalty status, name, city from your CUSTOMER_DIM table).
- Use XDM ExperienceEvent for "what the customer did" (e.g., events like page views, purchases, cart additions from your FACT_SALES table).
2. Map Your Fields:
- Map columns from your Snowflake customer table to standard XDM field groups like Demographic Details.
- Map columns from your events table to field groups like Commerce Details.
3. The Most Important Step: Identity Mapping: This is the key to making real-time personalization work. You must tell AEP how to stitch data together to form a single customer profile.
Thanks,
Amit
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.