The reason Snowflake has gained so much traction is that it removes a significant amount of operational complexity from data warehousing. Traditional on-premise warehouses required teams of DBAs managing hardware, storage, and query performance tuning. Snowflake handles all of that automatically — you focus on data and queries, not infrastructure.
It also runs on AWS, Azure, and GCP without locking you into a single cloud provider, which is appealing to larger organisations running multi-cloud strategies.