How to query profiles with events

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.