Cloud adoption in organizations has picked up momentum recently and the pandemic has reinforced the need to digitization and cloud migration especially in context of data warehousing and BI and so the importance of data modelling which is often overlooked as a component of cloud computing, has also gained thrust. However, there are associated data modelling challenges with cloud hosted database and if we follow the best practices supported by data modelling tools, it can overcome those challenges and ease the migration journey.