I have below SQL query in Automation:

select top(10) 
, dateunsubscribed
, status
, subscriberkey
, 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 '19 at 7:41

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

FROM ENT._subscribers

| improve this answer | |
  • If i copy paste the same automation to production, do i need to remove ENT. from my sql? – krishna kundan Jul 18 '19 at 8:11
  • I would do it this way and it will work – jc_mc Jul 18 '19 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 '19 at 19:55
  • @Tyler, How to check whether Production is at the enterprose level or not? – krishna kundan Jul 19 '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.