SQL Query needed to copy the data from synchronized DE to a new/regular DE in Marketing Cloud:
Marketing cloud and Sandbox have been connected. Contacts from Sandbox are synced with Marketing Cloud (coming in Synchrnized Data Extension). Now, I want to create a new Data Extension in Marketing Cloud copying all data from this Synchronized Data Extension and then automatically updating this new Data Extension using automation/Sql Query.
I have created the new Data Extensions with same fields as are there in the Synchronized Data Extension. Now I am trying to create an activity in automation studio which will contain the sql query (to copy the data from Synchronized DE to this new DE). I am not aware about the queries/sql, can someone please tell me the exact query for this?