I have created a filter from a synchronized DE.
I would like this filter DE to be automatically synchronized when new data gets added or removed.
When trying to create an automation > activity type > SQL Query, hence the type of the DE is "Filter" it does not show in the list to assign a query to the DE.
When trying to create an automation > activity type > Filter, it's only allowing me to select DEs from the "Data Filters" folder.
Currently, to achieve this task, Instead of creating a filtered DE, I create a standard DE, and link a Query to it and drop it in automation. I don't like this process because to duplicate the syncronized DE to a standard DE, I make an API call to fetch all the fields from the Synchronized DE and then I use another API call to post the new DE with all the fields.
Where for creating a filter from a synchronized DE, the new "Filtered DE" gets created with all the new fields automatically.
Is there a way to make a filtered DE, based on a synchronized Data Extension, synchronized? Or perhaps a better way to create duplicate DE from a Synchronized DE without having to manually type in all the fields or to use an API to do so?