Dynamic Namespace mapping with Date


I want to push data automatically everyday at 00:00 to a new collection named “collection-YYYY-MM-dd”

is there a way to do it with dynamic namespaces ? can I use onther Field with timestamp and convert it with kafka-connect ?
hwo can I add indexes to the created collection ?

thanks !


@Ayoub_BENHASSINE , this is similar to this request Howto override topics collection name as one instruction

I think, I am missing something.