1

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

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.

2

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.

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.