I am trying to dump data from a Salesforce object into a Salesforce Data Extension. I am not getting an errors but the data refuses to populate. I can't figure out what I am doing wrong! I have tried Append, Update, and Overwrite as well.
I am in our parent account so I don't think I need the Ent. prefix. Here is the SQL Query
SELECT DISTINCT AccountNumber, PersonEmail, Phone, Name, Status__pc, Agent_Type__c FROM Account_Salesforce WHERE Status__pc = 'Active' AND Agent_Type__c = 'Concierge'
And here is the set-up for the target data extension:
Like I stated I am getting no run-time errors and the query seems super basic. I have no idea why it won't populate!