Here is my problem : I'm not able to copy some (58K) Contacts from a Synchronized Data Extension to a Sendable Standard Data Extension, with a query.
Here are some elements :
- In my connector, I have a filter which will allow contacts with the field 'DoNotSendToMc' = false to enter into my Synchronized Data Extension called Contact_Salesforce
- Today, with Jitterbit, I changed the value of "DoNotSendToMc" from True to False, on Salesforce, on 58K Contacts. I didn't change anything on the 1 000 000 Contacts I already had before.
- Those 58K Contacts are now in my Synchronized Data Extension, and I want to send all my contacts (1 058 000) into a Standard Data Extension)
- I performed the simplest test I could : I created a Standard Data Extension with only 1 field called Id. I did NOT select "Sendable" for this Data Extension, and I populate it with a simple query
SELECT Id FROM Contact_Salesforce
The result in my Data Extension is: 1 058 000 Contacts. My 58 Contacts are here, I can find some of them with a search.
Then I cleared the Data Extension and changed the parameter to "Sendable", and run the same query with Overwrite. The result in my Data Extension is: 1 000 000 Contacts.
I'm missing something but for now I don't understand what check I can perform. Do you have any idea to help me ?
Thank you for your help !