[SalesForce] How to duplicate synchronized data extension and put in data extensions folder

Having the use case would help for long term viability of the solution. But, assuming that you're going to make a one time copy of the original DE (or copy and overwrite in the future), and also assuming that all of your field names are exactly the same...

Create a SQL Query:

select * from DE1

Within the SQL settings, select the new data extension as the target, and choose to overwrite.

If you have re-labeled any fields in the new data extension, then you'll have to update the query to something like:

select Id, FirstName, email as 'email address', LastName from DE1

Note that, in the example above, 'email' is the field label in DE1 while 'email address' is the corresponding field label in DE2.

Life is made easier by keeping the field labels the same.

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.

SELECT *
FROM Account_Salesforce

However if you are doing this from a child business unit, you'll need to add .ent prefix.

SELECT *
FROM ent.[Account_Salesforce]

You can follow these steps to set it all up:

1. Create a new Data Extension with same field set.
2. In Automation Studio create new SQL Query Activity.
3. Write the query and select the newly created Data Extension as the target.
4. Check syntax / Save.
5. Test it. If all works, then schedule the Automation to run by some period of time, like once in an hour or day.