Ask HN: Which data warehouse would you choose for your infrastructure in 2022?

We're evaluating multiple providers (Snowflake, BigQuery, AWS Redshift, Azure). What are good criteria you would recommend thinking about? Also, anecdotes of your personal pain points with using these providers would be helpful! Examples of criteria might include:

* support for querying unstructured data

* scalability and performance

* pricing models (storage / compute)