1

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:

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? – Adam Spriggs Jan 30 at 20:40
  • Nope, I keep running it and I am getting nothing – Nate Harris Jan 30 at 20:41
  • Does it populate with the where-clause removed? And how many rows are in Account_Salesforce and has it finished syncing? – Adam Spriggs Jan 30 at 20:41
  • Let me test one second – Nate Harris Jan 30 at 20:41
  • No population when the where-clause is removed – Nate Harris Jan 30 at 20:43
0

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

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.