I'm looking for a way to mirror a synchronised data extension into a local data extension.
My SDE is currently counting +- 6mio records and 100 columns (and yes, we need them!). I feed the local DE with a query automation like:
SELECT * FROM ent.SDE WHERE ...
currently, it takes up to 30min (if I don't get a timeout error :-) ) Is there a way to speed up the process??