I need to essentially mimic a synchronized data extension but in the data extensions folder. I think what I need to do is duplicate the synched data extension into the DE folder, populate it from a query in an automation that runs at a set interval.
My problem; in regular (non-synched) data extensions, I can just duplicate the data extension from the menu and get all fields in my new data extension. This doesn't seem possible in the menu of the synchronized data extension. Is there a way to copy all the fields in the synched data extension to a new data extension?