The biggest difference is that Y-Sweet is built around object storage (i.e. S3 and friends) rather than a database.
This allows writes to scale horizontally without a central database being the bottleneck. It’s also a much cheaper way to store lots of documents accumulating over time on S3 than in a database. This is because compute scales with how much data you actually access, not how much data you store.