[FridgeSeal]

I could not disagree more.

Working with it was fraught with issues. Performance was mediocre at best, it was horribly expensive, Python and JS client libs had re-occurring issues with disconnecting and reconnecting. The advice given to us around scaling concurrent connections was bizarre at best. Teammates had numerous issues where it was clear corners had been cut in handling some edge cases around handling certain unicode characters. Their Snowpipe "streaming" implementation was...not good. The idea of having having compute workers that "spun up and down" sounded good in theory, but in practice lead to more bottlenecks and delays than anything else.

The AWS outage last year that prevented you from provisioning new instances essentially crippled our snowflake DB.

I almost go out of my way to recommend people _not_ use it. I keep seeing it pop up, but mostly because it seems they're doing what Mongo DB did in the early days and just throw marketing money to capture mindshare as opposed to being an actually good product.

We changed to ClickHouse and the difference was literally night-and-day. The performance especially was far superior.

[veritas3241]

Sorry you had a bad experience with it. Certainly compared to redshift it's a dream. I use it every day and it's been great for us.