I have synchronized two De from sales Cloud successfully and I'm now trying to run a query using them. I get an error message which tells they are unknown. I wonder which can be the error causing this issue.

As this query will have to populate a new data extension , I kindly ask you to confirm this is the correct process: 1. create a DE manually inserting all the fields I need (they will be a selection of those in the synchronized DE) 1. write the query with automation 2. create an automation which import data from query to the standard DE created at point 1

I thank you all for the help, G

  • is this in a child BU? you would need to add ENT. ENT.contact_salesforce – EazyE May 19 at 15:25
  • can you provide the query syntax? – David Devoy May 19 at 18:53
  • Hi, the first I'm trying to create a standard DE from a Synch one, with a shorter list of attribute and option Overwrite. This is the syntax SELECT PersonEmail, LastName, FirstName, Name, IsSubscribed__c FROM Account_Salesforce. The Account_Salesforce is the sync DE. the query should send data to a Standard DE I have created with the exact fields you see in the query. Thanks for helping so much – Giorgia B. May 19 at 19:00
  • @DavidDevoy are you able to help please? this is the synthax SELECT Id, PersonEmail, LastName, FirstName, Name, IsSubscribed__c FROM Account_Salesforce. the Id is the primary key. I have the same issue on another DE (called Items) where the primary Key is the OrderID related to these products. Thanks again – Giorgia B. May 19 at 21:01
  • 1
    @DavidDevoy you are write I has some null fields which were required in the DE. Thanks for your help so much – Giorgia B. May 20 at 19:01

Your Answer

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

Browse other questions tagged or ask your own question.