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, 
FROM Account_Salesforce
WHERE Status__pc = 'Active'
AND Agent_Type__c = 'Concierge'

And here is the set-up for the target data extension:

enter image description here

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!

  • Anything showing in the Activity Log for the Query? Jan 30, 2019 at 20:40
  • Nope, I keep running it and I am getting nothing Jan 30, 2019 at 20:41
  • Does it populate with the where-clause removed? And how many rows are in Account_Salesforce and has it finished syncing? Jan 30, 2019 at 20:41
  • Let me test one second Jan 30, 2019 at 20:41
  • No population when the where-clause is removed Jan 30, 2019 at 20:43

1 Answer 1


The issue was with data truncation, the issue was one rouge row that had more than the allotted characters!

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .