In Marketing Cloud - I cannot view internal data views (_Sent, _Click, _Open, _Bounce) using a SQL Query Activity. Is access to data views part of business unit set up or is this a permissions issue?
-
what is the error message you are getting?– EazyEJan 22, 2020 at 18:44
-
Here is an example of the message that I get when trying to validate the syntax in SQL Query activity "Errors: [_Job] is not a known data extension or system data view. You can only query existing data extensions or system data views."– Becky AllturnaODJan 23, 2020 at 18:03
-
I can add the "ent" to the beginning ("ent._Job") - but then I get only information at the parent level. No information from my specific business unit.– Becky AllturnaODJan 23, 2020 at 18:05
-
Also - I have used the same query in other business units for the same client, so I know it works.– Becky AllturnaODJan 23, 2020 at 18:05