I am trying to create a copy of a Synchronized Contact Data Extension (from Salesforce) into the non Synchronized Data extension using a SQL query activity.
Can someone give me an example of the query I would use?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
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.