I have a use case where profile and event data are present in AWS Redshift database. I created required schema using XDM profile, enabled the schema for profile and created dataset using schema , also enabled dataset for profile.
Same steps i did for the event data i.e. Created required schema using XDM experience event, enabled the schema for profile and created dataset using schema , also enabled dataset for profile.
After batch ingesting the data using the existing AWS Redshift connector i see all the data in profile correctly however the event data related to the profile is missing. Both profile schema and event schema has the same primary identity linked to the same namespace.
I checked monitoring and I see success.
However one strange thing i noticed while ingesting event data (I see negative count of records ingested as attached below)
Any thoughts on why I am missing event data on profile ?
Solved! Go to Solution.
Views
Replies
Total Likes
Finally worked for me
To test, I created 2 profile Schemas(ProfileA, ProfileB) and 2 Experience Event schemas(Event A, Event B).
In the first set of schema(ProfileA,EventA) I just added a primary identity and later ingested the data.
In the second set of schema(ProfileB,EventB) I added a primary identity + Added a field group "AEP Web SDK Experience Event" in EventB schema
In the profile data ingested in set A, i can't see event data.
In the set B where I added field group "AEP Web SDK Experience Event" i could see event data in profile.
This made me reach to a conclusion that "AEP Web SDK Experience Event" field group is required in Experience Event schemas if we want to see event data in Profile.
@arijitg @_Manoj_Kumar_ and other community members - Is that true?
Hi @arpan-garg ,
Can you once check the timestamp for your events if they're older than 30 days?
Can you do a profile lookup on an identity where timestamp are within 30 days if you can see events listed?
By any chance did you load event dataset and then dropped and recreated the dataset and reloaded?
Regards,
Arijit Ghosh
Views
Replies
Total Likes
Hi @arijitg - I created a new dataset and a new schema and ingested the data with timestamp of yesterday. Still I see records being skipped and records ingested in negative
Views
Replies
Total Likes
I see this document from Adobe https://experienceleague.adobe.com/docs/experience-cloud-kcs/kbarticles/KA-19839.html?lang=en as per this its impossible to see event data ingested via csv. Is that true?
Views
Replies
Total Likes
Hello @arpan-garg No it is not true, CSV uploaded events will be visible in the events tab.
All these values should be populated in event data to make it work.
Views
Replies
Total Likes
@_Manoj_Kumar_ - This is what i believe as well .
Views
Replies
Total Likes
Hi @arpan-garg is that possible you tried to ingest _id which are already present in platform (ingested already may be to some other dataset)? In that case these records shouldn't reflect in UPS. This is a known guardrail to avoid duplicate events in system.
Views
Replies
Total Likes
Hi @arijitg - Yes i made sure all the id's ingested are not same as previously ingested ids
Views
Replies
Total Likes
Finally worked for me
To test, I created 2 profile Schemas(ProfileA, ProfileB) and 2 Experience Event schemas(Event A, Event B).
In the first set of schema(ProfileA,EventA) I just added a primary identity and later ingested the data.
In the second set of schema(ProfileB,EventB) I added a primary identity + Added a field group "AEP Web SDK Experience Event" in EventB schema
In the profile data ingested in set A, i can't see event data.
In the set B where I added field group "AEP Web SDK Experience Event" i could see event data in profile.
This made me reach to a conclusion that "AEP Web SDK Experience Event" field group is required in Experience Event schemas if we want to see event data in Profile.
@arijitg @_Manoj_Kumar_ and other community members - Is that true?
Hello @arpan-garg
Yes, that is correct. The WEb SDK event field group should be the part of Experience event schema.
Views
Likes
Replies
Views
Likes
Replies