So I am really new to this SFMC platform, but not salesforce, nor SQL. I have a query that should return all subscribers, just for a test. No matter what I do, or what query I write, I get nothing back. 0 records every time. I first started with this query:
select c.subscriberid , c.subscriberKey , s.EmailAddress , c.EventDate from _Subscribers as s left join _Click as c on (c.subscriberId = s.subscriberId) left join _Open as o on (o.subscriberId = s.subscriberId) where o.eventDate > '2016-07-01' AND c.eventDate > '2016-07-01'
I got nothing back, so then I tried to make a simple query that would have to return something. So I ran this:
SELECT top 5 subscriberKey, subscriberId, EmailAddress from _subscribers
I even tried this:
SELECT subscriberKey, subscriberId, EmailAddress from _subscribers
And still, in my data extensions, I get nothing back. Syntax validates, data extension validates, but 0 records. Can anyone direct me as to what I am doing wrong here? Seems pretty simple, but nothing I have tried works. At all. Thanks!