"You’re actually smarter than this, you need to switch from SQL to Cosmos for a cloud migration on Azure."

Switching from a relational database to a NoSQL database to store entity data isn't smart.

Neither MongoDB (a document database) nor Cassandra (a distributed, wide column database) -- the database engines that power the Cosmos service -- are not well suited for structured, consistent entity data sets, where each well-defined entity (e.g. person, place, or thing) has a common set of attributes. Well-designed relational tables are.

Relatively few people will actually need Cassandra's scale, and there are a number of excellent managed, cloud-based relational services available. Introducing the managed service and scalability concerns really just clouds (no pun intended) the water here.

Understanding and using tools for the purposes they were intended makes everyone's lives simpler.