I need to delete 2M Contacts from All contacts.
Actually, my colleague synced the Contact object from Salesforce without checking the box "only import contact with email address". I checked it later in order to only get contacts with email address in the Contact synchronized DE.
However, it seems that all the contacts that have been imported once on SFMC through MC connector stay in the SFMC in All Contacts... Is there any to query the All Contacts table in order to get all the contacts without email address and import them into a Data Extension, so that we can use the delete contact feature on a Data Extension ? If not would you have some solution that could address my need ?