How to query profiles with events

[GabrielaNa1]

Hi,

I have a number of profiles in the Real Time Customer Profile in Adobe Experience platform. I also have a dataset/schema for Events (XDM Experience Event) and I loaded some event data for the above profiles. If I go under Profiles and check a few of these profiles I can see the events attached to the profile under the Event tab.

I think that I can query the profiles using something like this:

select * from profile_snapshot_export_<some_unique_Id> 

and I can parse the available columns in drill down for any kind of information related to the profile and its Attributes.

What I want to also do is to query the events linked to the profile so I can verify any audience I build against the actual numbers in the profile.

Something like this:

select * from profile_snapshot_export_<some_unique_Id> as t1

inner join <Events table> as t2

where t1.Attribute1= "Value1"

and t2. EventType="CampaignDropped"

and t2.EventDropDate betwen ... and ...

Any directions in building such a query will be greatly appreciated. Any documentation regarding important tables in the Platform data model will be very useful.

Thanks.

[jayakrishnaaparthasarathy]

Hi @GabrielaNa1  - See if this is helpful to get a query. Not sure, I have just come across on the below document and thought to share it here.

https://experienceleague.adobe.com/en/docs/experience-platform/query/best-practices/writing-queries#...

Thank you,
Jayakrishnaa P.

[GabrielaNa1]

Hi,

That is a very useful article but unfortunately doesn't help at all with my question. Attached is a screenshot from the Events table under Profiles.

This view is clunky, you cannot see how many events, what types, what times, and so on - even for a single profile. You have to scroll and scroll to find something.

So, what I want is a way to query the profiles and these kinds of related events. To get that 360 view in a query or multiple queries. Is that possible?

[kautuk_sahni]

@GabrielaNa1 Did you find the suggestion helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!