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 Answer 1

  1. The System Data Extension (Data Views) have a name starting with an Underscore ("_Subscribers", "_Opens", etc.). Most of them are listed in official SFMC docs. Few missing from the official documentation you can find in Zuzanna's Post and my Docs
  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 Triggers, you should also leave Data Extensions with "abandoned_" prefix
  • Also one more to add to the list, there are some system data extensions that start with 'dts' such as 'dts_BatchStatus_7331050' Jan 8, 2021 at 11:57
  • I see you post a lot of links to a website that bears the same name as your username. Posting self-promotional links like this (without disclosing your affiliation) is considered spammy.
    – Luuklag
    Feb 17, 2021 at 21:40

You must log in to answer this question.

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