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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.