Rockset, the serverless
search and analytics company, today announced the availability of real-time SQL
on NoSQL data from Amazon DynamoDB -- a key-value and document database that delivers single-digit millisecond
performance at any scale. Hundreds of thousands of AWS customers have chosen
DynamoDB as their key-value and document database for mobile, web, gaming, ad
tech, Internet of Things (IoT) and other applications that need low-latency
data access at any scale.
With DynamoDB usage maturing in organizations, there is an increasing need for
operational analytics and real-time business reporting on it, which requires
the ability to search transactional data, run aggregations and join the data
with other datasets. As stated in the Amazon Web Services blog,
"DynamoDB is not suitable for running scan operations or fetching a large
volume of data because it's designed for fast lookup using partition keys.
Additionally, there are a number of constraints (like lack of support for
powerful SQL functions such as group by, having, intersect and joins) in
running complex queries against DynamoDB."
Rockset is an operational analytics engine that is entirely serverless, which
means it does not require provisioning, capacity planning or server
administration in the cloud. Developers and data engineers can run complex
queries with the full power of SQL and choose to visualize the data in live
dashboards such as Tableau, or build custom applications using Rockset's
real-time SQL.
"Once provided with read access to a DynamoDB table, Rockset reflects changes
as they occur in DynamoDB by making use of changelogs in DynamoDB streams. This
gives users an up-to-date (within a few seconds) indexed version of their
DynamoDB table in Rockset," said Venkat Venkataramani, CEO of Rockset
"And each SQL query against this table is distributed and executed in
parallel to ensure that query results return in milliseconds."
With this release, Rockset supports the ability to:
- Visualize DynamoDB data in
leading SQL-based visualization tools, including BI market leader Tableau,
Apache Superset, Redash and Grafana, in real time.
- Build custom interactive
dashboards and real-time applications using SQL on DynamoDB data.
- Join DynamoDB data with data
in Kafka event streams, Amazon Kinesis or Amazon S3.
Customers embrace DynamoDB analytics with
Rockset:
"It's extremely valuable for our operations team to have a complete picture of
how our hundreds of remote agents are being utilized, as we need to be able to
respond right away if there is any issue that may impact our service," says
Naresh Talluri, product manager at
FULL Creative.
"Building our dashboard on Rockset was the easiest way to analyze our call data
in DynamoDB and get real-time insights on the metrics we care about."
"We want to provide accountants an environment where they can work efficiently
with crypto, so it's important they have all the functionality they need to do
their job," says Yenwen Feng, CEO of
Decore.
"By building our search and analytics on top of Rockset, we make it possible
for accountants to find and review transactions as needed. Using DynamoDB and
Rockset together gives Decore the best of both worlds - fast writes and fast
analytics - with no need to trade off between the two. Queries that were
impossible with DynamoDB alone are now completing in milliseconds with Rockset.
Anyone running analytics on DynamoDB can get better performance just by hooking
up their applications to Rockset and connecting to DynamoDB."