Snowflake is the big well-known user, but it seems there are many smaller production users as well.

I'm planning to migrate to it. It's quite simply the best distributed database out there today.

Would you self host foundationDB? It seems there aren't many providers.

Yes, definitely! I have been self-hosting everything for years now, and I'm very happy. Even a three-machine bare-metal cluster has impressive computing power and is difficult to grow out of. I can't envision growing out of a five-machine cluster.

I found higher-level solutions (like AWS) to be slow, complicated and expensive, and I really can't see any reasons to use them.

Open Source Stalwart E-mail(IMAP/JMAP) server recommends using FoundationDB for distributed setup backends.

https://stalw.art/docs/storage/backends/foundationdb

Datadog https://www.datadoghq.com/blog/engineering/introducing-husky...

Snowflake used it when I worked there and I assume still does.

Would you mind sharing what made you quit Snowflake? (I'm considering applying there)

Griffin https://www.juxt.pro/blog/clojure-in-griffin/

Deno KV

SurrealDB

Exoscale

Wavefront