I am attempting to query the SentEvent object, with related columns of Subscriber, as shown in the query below. This query locks up consistently and never produces results.
I have successfully connected to ExactTarget using the User Authentication (user is set up as API user in Marketing Cloud). I have been able to run queries against other objects, such as the Send and Subscriber Objects and have been able to access the SentEvent when the related columns to Subscriber are unchecked.
Thanks for your help.
Code: Select all
SELECT t.SendID,
t.SubscriberKey,
t.EventDate,
t.Client_ID,
t.EventType,
t.BatchID,
t.TriggeredSendDefinitionObjectID,
t.ListID,
t.PartnerKey,
t.SubscriberID,
SubscriberID.ID AS "SubscriberID.ID",
SubscriberID.PartnerKey AS "SubscriberID.PartnerKey",
SubscriberID.CreatedDate AS "SubscriberID.CreatedDate",
SubscriberID.Client_ID AS "SubscriberID.Client_ID",
SubscriberID.Client_PartnerClientKey AS "SubscriberID.Client_PartnerClientKey",
SubscriberID.EmailAddress AS "SubscriberID.EmailAddress",
SubscriberID.SubscriberKey AS "SubscriberID.SubscriberKey",
SubscriberID.UnsubscribedDate AS "SubscriberID.UnsubscribedDate",
SubscriberID.Status AS "SubscriberID.Status",
SubscriberID.EmailTypePreference AS "SubscriberID.EmailTypePreference"
FROM SentEvent AS t
LEFT OUTER JOIN Subscriber AS SubscriberID ON t.SubscriberID = SubscriberID.ID
WHERE ((t.EventDate > '2016-09-01 09:42:05'))
LIMIT 100