Have you used both? I used to use Snowflake at a former company. Snowflake has top class support for semi-structured data, for example. I found it really easy to use and highly flexible/featured compared to Redshift.
No, I haven't. I mainly work with Vertica and did some troubleshooting on a Redshift cluster. I've mainly read comparisons of performance and price/perf vs. those platforms.
Reading through their docs their semi-structured data support is similar to Vertica's flex tables. It's a handy feature, but not critical IME.
Reading through their docs their semi-structured data support is similar to Vertica's flex tables. It's a handy feature, but not critical IME.