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.<p>FiveTran had a fantastic benchmark on GitHub (https://news.ycombinator.com/item?id=17952205) but I want to hear direct user experiences.<p>And specifically, if you are using <i></i><i>Gen2</i><i></i> (https://www.zdnet.com/article/azure-sql-data-warehouse-gen-2-microsofts-shot-across-amazons-bow/)<p>1. What did you like about it over XYZ DW? What was lacking compared to XYZ DW?<p>2. How were development tools and third party tool support?<p>3. Satisfied with performance?
We did a migration from Vertica to ADW a couple of years ago.<p>ADW was slower and about 2x more expensive than Vertica on 8-year-old hardware, and it hit its node limit at around 60. Loading was also a PITA; there was no json support.