Combine collections from various databases into one database
It would be helpful to be able to combine collections with the same name from various databases into a single "global" database in the Federated Database Storage Configuration.
Imagine you have a multi tenant application where you have DatabaseCustomerFoo and DatabaseCustomerBar, and each of them has a collection called "events". It would be great if you could easily combine those (at scale) through the storage configuration, so in this instance you would have a database: DatabaseCustomerGlobal and a collection: events which federated over both DatabaseCustomerBar.events and DatabaseCustomerFoo.events.
AdminBenjamin
(Admin, MongoDB)
shared this idea
We've added the capability to dynamically combine name spaces in underlying clusters using the Database Regex in the Storage Configuration for Atlas Data Federation.