Chose Snowflake
Redshift compute and storage can be scaled up/down together (though they added some features recently, they don't quite add up). I haven't tried Avalanche or Firebolt but would love to in the near future, due to their pedigree or revolutionary billing methods.
Independently Invited by TrustRadius
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info