Is it possible to clear Synchronized data extension? I want to clear all data and resynch as I want to remove some fields from Synchronized data extension.

  • 1
    Yes, It's possible.
    – SFMC_User
    Jun 6 '17 at 10:17
  • If you want to remove some field from Sync DE, Go to Sync Object(Contact Builder ), click on Edit field, Un-check those fields and refresh the Object.
    – SFMC_User
    Jun 6 '17 at 10:23
  • Thanks Vikas, when I go to Data Extensions in Contact Builder and open any Synchronized data extension the Clear Records and Add Records buttons are both disabled. Is there some access issue or am I missing anything?
    – Vandana
    Jun 6 '17 at 22:57
  • Contact Builder>Data Sources>Click on Synchronized tab> Where you will get all the entities and Attributes> Type your sync DE name in Synchronized Entities search box, Later you can follow above steps
    – SFMC_User
    Jun 7 '17 at 8:33

As Vikas said, you can edit the field mapping and remove the sync - this will automatically remove them from the synchronized DE, albeit it might take some time to fully reflect.

In order to clear the data, you need to press this very small button shown below, although it sounds like you would do fine with simply deleting the fields? (i.e. removing the mapping)

enter image description here

  • how can we edit the field mapping and remove the sync? When I go to edit fields, I can unmap only the optional fields.
    – Mike Marks
    Nov 9 '18 at 21:49
  • You cannot delete the required fields I believe (you're thinking about the IDs right?) - they are required to build out the data model in Marketing Cloud. Nov 16 '18 at 9:51

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.