I have written this query:
SELECT Client_Id__c, Abandoned_Cart_Id__c, Status__c, Total_Amount__c FROM Abandoned_Cart__c_Salesforce
with Overwrite option. and the synthax is correct.
The issue is that the destination DE doesn't receive this data and I don't understand why. The attributes' names are correct and in the query I have included all the fields of the DE. Could you please help? Thanks