Try the following SQL query to copy data from a Salesforce Synchronised Data Extension to a regular Data Extension.
Following example is based on the Account object.
However if you are doing this from a child business unit, you'll need to add
You can follow these steps to set it all up:
- Create a new Data Extension with same field set.
- In Automation Studio create new SQL Query Activity.
- Write the query and select the newly created Data Extension as the target.
- Check syntax / Save.
- Test it. If all works, then schedule the Automation to run by some period of time, like once in an hour or day.