I have an automation that can grab data from enhanced FTP. This part is done already.

However, I'm puzzling on how can I insert data from parent BU's data extension to child BU's to data extension? You can assume they have the same column settings.

  • are you inserting records from FTP? for different BUs
    – Ravi.A
    Apr 18, 2018 at 5:17
  • based on that Ftp Account you can insert records in different Business account
    – Ravi.A
    Apr 18, 2018 at 5:19
  • I just have parent BUs FTP A/C
    – PY Yick
    Apr 18, 2018 at 5:26
  • you can insert records manually create one csv file then goto child Bu and open Target DE and insert records
    – Ravi.A
    Apr 18, 2018 at 5:41
  • 1
    Might have to import to a DE in the parent account BU, and then run a sql query to transfer the records to the child BU's data extension Apr 18, 2018 at 6:01

2 Answers 2


If you have the data extension in the Parent BU as a shared data extension. You can write a query to copy data from it into the child BU DE.

Create a query in the Child BU which does this:

Select *
From ENT.ParentBU_DEName

@PY Yick using Query you can achieve this one try like this write this in Child BU

select * from source DE where OYBAccountID='parent Bu'

You must log in to answer this question.

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