We have a SFMC org connected to SF CRM with one parent BU and one child BU. We need the Synchronized DEs from CRM to be available in the Child BU.
As we can not move the Sync DEs in a Shared folder, we have to create brand new DEs containing the Sync DEs data in the Shared folder.
As there are many fields on the Sync DEs with API names of the fields, it is a very tedious work to create a DE from scratch to copy the Sync DE...
I wanted to create Filtered DEs from the Sync DEs in order to get the whole data without having to create DEs from scratch with many fields. And then use an automation to refresh it every 15 minutes.
Is there any warnings/risks/drawbacks to use Filtered for that purpose that VS creating DEs from scratch and fill them with SQL queries (refreshed by an automation) ?
Which solution is the best or more convenient ?