I have below SQL query in Automation:

SELECT TOP(10) EmailAddress AS EmailAddress,DateUnsubscribed AS DateUnsubscribed,
Status AS Status,SubscriberKey AS SubscriberKey,SubscriberID AS SubscriberID 
FROM _subscribers

It doesn't populate any records in Data Extension while All Subscriber has lot of records?

  • are you getting any error ? – pkharries Jul 18 at 7:41

Add a prefix of "ENT" if running the query from a child Business Unit.

"FROM ENT._subscribers"

  • If i copy paste the same automation to production, do i need to remove ENT. from my sql? – krishna kundan Jul 18 at 8:11
  • I would do it this way and it will work – jclobro Jul 18 at 8:17
  • @krishnakundan it will still work if you keep or remove the ENT. when moving to production, assuming production is at the enterprise level. – Tyler Jul 18 at 19:55
  • @Tyler, How to check whether Production is at the enterprose level or not? – krishna kundan Jul 19 at 2:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.