I'm trying to query all subscribers through an SQL query.

I've copied a query which I am using in another instance of marketing cloud which works fine. However in the new instance the query activity is giving me an error:

Errors: _subscribers is not a known data extension or system data view. You can only query existing data extensions or system data views.

does anyone know why its saying _subscribers is not a data view in the system?

Query is below -

    sfdc.Id as SubscriberKey,
    sfdc.Email as EmailAddress,
    (SELECT con.Id, con.Email FROM Contact_Salesforce con WITH (NOLOCK)
    SELECT lead.Id, lead.Email FROM Lead_Salesforce lead WITH (NOLOCK)
    ) sfdc
    _subscribers as allsub WITH (NOLOCK)
ON sfdc.Id = allsub.SubscriberKey
WHERE sfdc.Email != allsub.EmailAddress

2 Answers 2


You are probably trying to query it in a child business unit of an enterprise account which is giving you this error. To fix it prepend “ent.” To _subscriber (I.e. ent._subscribers) or write the query in the top level BU.

In addition to this, you want to be querying the _ListSubscribers data view with ListID corresponding to your all subscribers list. You can get this by going to the all subscribers list and checking properties


Just made a ticket with support.

turns out that data view querying was not provisioned for the account. Issue has been fixed after this was provisioned.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .