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?

enter image description here(Kindly see the attachment)

1 Answer 1


You need to specify each column name. In your case, the ContactKey column should be stated in your query ..

Check out the help for more information about SQL Activities;

  • Thanks Rachid. Issue is, there is a field in Synchronized DE with the name '_ContactKey' (starting with underscore) and when I create my own DE, I can't name a field starting with an underscore. Could this be the issue?
    – Ajay
    Jun 16, 2020 at 9:29
  • 1
    Yes this could be .. in that case, you have to write something like this select [_ContactKey] as ContactKey from synchDE Jun 16, 2020 at 9:41
  • Thanks @SwatiMishra got the way around.
    – Ajay
    Jun 16, 2020 at 10:11

You must log in to answer this question.

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