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:
- A Snowflake schema is a way to store data efficiently for analysis and reporting.
- An XDM schema is a common language to describe customer experiences in real-time for activation and personalization.
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
