[ramraj07]

Snowflake is capturing a large market share in analytics industries thanks to its “just works” feature. I’m a massive fan.

But in the end, snowflake stores the data in S3 as partitions. If you want to update a single value you have to replace the entire s3 partition. Similarly you need to read a reasonable amount of s3 data to retrieve even a single record. Thus you’re never going to get responses shorter than half a second (at best). As long as you don’t try and game around that limitation it works great.

Materialize up here also follows the same model in the end FWIW.