We're looking into Redshift and Snowflake for a project since some of our sister companies use it and they seem more established but we're also on the Microsoft stack and use Azure for miscellaneous small projects. Our DW will be roughly 2-4TB initially.
FiveTran had a fantastic benchmark on GitHub (https://news.ycombinator.com/item?id=17952205) but I want to hear direct user experiences.
And specifically, if you are using Gen2 (https://www.zdnet.com/article/azure-sql-data-warehouse-gen-2-microsofts-shot-across-amazons-bow/)
1. What did you like about it over XYZ DW? What was lacking compared to XYZ DW?
2. How were development tools and third party tool support?
3. Satisfied with performance?