Amazon Athena vs. Scylla

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Incentivized

Scylla is well suited for high-throughput scenarios where keyed data must be read or written with consistently low latency. It's less appropriate for use cases requiring relational queries, secondary indexes, or more structured data sets.

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• Low-latency reads
• CQL has a familiar syntax
• Parity with Cassandra
• Practical features

• Query manager can incoperate GUI based query designer
• Auto-completion engine sometimes overwrite the query
• Time range selection should be implicit

Incentivized

• Better documentation for best practices (e.g., how to effectively use connection pooling)

Very easy-to-understand syntax--uses CQL (same as Cassandra), which has many similarities to standard SQL. There are some gotchas, however, that must be known during schema development.

The Scylla cloud support team is incredibly responsive and proactive.

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Incentivized

Scylla has a quick learning curve (same as Cassandra) compared to other proprietary solutions like BigTable. It supports higher throughput and lower latency that other NoSQL databases like MongoDB, which sacrifice those features for more flexibility and unique features.

• Easy to query terabytes of data with faster response
• Pricing model is also cheap
• No indexing and partitioning

Incentivized

• Addresses latency requirements of our platform