I want to see all emails sent to a specific subscriber
I have created a DE with the field
subscriberKey is only and primary key
I then want to set up an Query Activity based on the Query
SELECT j.EmailName, s.EmailAddress from _Job j INNER JOIN _Sent se on j.JobID = se.JobID INNER JOIN _Subscribers s ON se.SubscriberKey = s.SubscriberKey WHERE se.EventDate < GetDate()
However as the
subscriberKey is required within my Target DE I get this error message when I want to save the Query
A problem occurred creating your query definition. Please contact Customer Service for additional information. Name: Email sent to spec individual External Key: a7fc18e8-051d-4f53-8d98-5bf73b0dc6f8 Error saving the Query field.Field 'SubscriberKey' is a required for the Target Data Extension. Ensure this field is specified in your query text.
Where do I enter the
subscriberKey for the specific individual in the query text?