We are currently performing a clean up on our marketing cloud instance with 30 BUs.

Currently, we have a ssjs script that fetches all the data extensions and it's row count using the undocumented API mentioned here. The use case is to delete the data extensions that are junk/test using this method. The problem is while fetching the data extensions, we are also getting a list of System data extensions(not visible on UI). Is there a way where we can identify these data extensions, so that we can exclude them from our script? I have checked the Data Extension object and it has no field to identify this.

  1. The System Data Extensions (Data Views) have a name starting with an Underscore ("_Subscribers", "_Opens", etc.). Most of them are listed in SFMC docs. Few missing from the official documentation you can find in Zuzanna's Post
  2. Additionally take into consideration the Einstein Data Extensions if you have them enabled. Those start with either "IGO_", "PI_" and "Einstein_" prefixes.
  3. If you are using Behavioral Trigger, you should also leave Data Extensions with "abandoned_" prefix

Best regards, Mateusz

  • Also one more to add to the list, there are some system data extensions that start with 'dts' such as 'dts_BatchStatus_7331050' – Swati Mishra Jan 8 at 11:57

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.