2

Is it possible to query the data view (_Job) of a child Business Unit from the parent Business Unit?

Something like

SELECT * FROM C1234567._Job

Where 1234567 is the MID of the child BU.

2 Answers 2

4

According to SFMC Support, you cannot query a Child BU from the Parent, but you can query the Parent from the Child.

SELECT * FROM _Job --This is for the child BU when the query is run in the child BU Account.

And

SELECT * FROM ENT._Job --This is for the Parent BU when the query is run in the child BU Account.
2

I dont believe this is possible. _Job is the only view which doesn't contain data for the enterprise at admin level (very annoying when all the rest do).

Unfortunately you'll need to create a shared DE and query data from each BUs _Job into that DE.

You must log in to answer this question.

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