Pros and Cons
DW has arguably a much better justification for "cloud" than most other things: it really can require tonnes of storage space and oodles of CPU power, and insofar as some "clouds" offer flexibility to firewall the throttles sometimes, and at others merely cruise, that does have benefits not so easily or cost-effectively replicated on-prem.
So for once I'm not entirely sceptical of "cloud" as use-case or value for money.
That said, for all the lovely Pros of power and flexibility, there 's the usual mammoth Con of security. DW feeds BI (business intelligence) systems helping companies figure out important stuff about products, customers, patterns, trends, clusters, an awful lot of which quickly goes beyond merely feeding traffic lights on some cubicle fauna's PowerPoint deck and becomes knowledge supporting competitive advantage. In short, DWs can hold crown jewels. There's actually not much point making the investment in them if they don't.
So whatever these guys are up to, are they seriously addressing the question of data security, privacy, confidentiality etc? Directors eager to "save money" (trans: get bonuses) do not think properly about security when hypnotised by the prospect of cash, but I suspect that this is an issue that's just going to get more and more airtime and generate increasing amounts of worry. Stuff like homomorphic encryption is nowhere near prime-time usefulness, "clouds" are simply not as secure as providers would have you believe, and you're gonna trust those guys to host data which, potentially, explains and enables your business's key competitive advantages?
Think hard. Think long.
PS: I always put "cloud" in quotes because it's a stupid name for what it does, beloved only of marketurds—though admittedly not quite such a flat-out lie as "AI".