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 -
SELECT sfdc.Id as SubscriberKey, sfdc.Email as EmailAddress, allsub.Status FROM (SELECT con.Id, con.Email FROM Contact_Salesforce con WITH (NOLOCK) UNION SELECT lead.Id, lead.Email FROM Lead_Salesforce lead WITH (NOLOCK) ) sfdc RIGHT JOIN _subscribers as allsub WITH (NOLOCK) ON sfdc.Id = allsub.SubscriberKey WHERE sfdc.Email != allsub.EmailAddress