Real-Time Search, Aggregations and Joins for DynamoDB
Build and scale read-intensive applications on DynamoDB data using a real-time indexing database designed for high QPS.
Powerful Analytics on DynamoDB Without Any ETL
Rockset is a fully managed service that enables real-time search and analytics on raw data from Amazon DynamoDB – with full featured SQL. Rockset takes an entirely new approach to loading, analyzing and serving data so that you can run powerful SQL analytics on data from DynamoDB without ETL.
Operational Analytics on Data from DynamoDB
As an operational data store optimized for transactions, DynamoDB is not well suited for analytics. Use Rockset to run powerful ad hoc analytical queries that are not possible on DynamoDB. New data is queryable in seconds and queries return in milliseconds, so performance is no longer a limiting factor.
How It Works
Rockset continuously tails DynamoDB so you don't have to manage ETL pipelines. It uses a Converged Index to deliver real-time SQL over REST with serverless auto-scaling under the hood.
Visualization Tools
Enable your business teams to visualize real-time event streams using dashboarding tools that they already know and love, using Rockset's JDBC connector and native support for standard SQL-based visualization tools.
Grafana
Grafana is an open observability platform for analytics and monitoring. Grafana requires a SQL backend and cannot query Kafka directly. Use Rockset to visualize Kafka events in Grafana.
Learn more
API Access
Insert, update and query data programmatically from custom application code using Rockset's client libraries wrapped on top of REST.
Python
# connect to Rockset
from rockset import Client, Q, F
rs = Client()
# build a query object
q = Q('hello_world').where(F['name'] == 'Jim Gray')
results = rs.sql(q)Rockset’s Python package is called rockset and the entire API is contained within a single Python module called rockset. APIs defined in the rockset module allow you to securely connect to the Rockset service, create or manage collections and query Rockset.
Learn more# connect to Rockset
from rockset import Client, Q, F
rs = Client()
# build a query object
q = Q('hello_world').where(F['name'] == 'Jim Gray')
results = rs.sql(q)Powerful Analytics on DynamoDB Without Any ETL
Resources
Related BlogComparing options for analytics on DynamoDB
A comparison of real-time analytics options on DynamoDB - Athena, Spark and Elastic - in terms of ease of setup, maintenance and query capability.
Read moreRelated BlogReal-time analytics on DynamoDB
We cover different approaches to real-time analytics on DynamoDB, including comparing real-time applications on ElastiCache and Rockset.
Read moreRelated BlogReal-time ETA prediction using DynamoDB and Kafka
Generate ETA predictions for a delivery service using real-time location and order data from Kafka and DynamoDB.
Read moreRelated BlogFleet management system on DynamoDB and Rockset
This post outlines a fleet management solution using IoT and data technologies, such as DynamoDB, Lambda, and Rockset.
Read moreRelated BlogDecore uses Rockset for search & analytics on DynamoDB
Decore uses Rockset for fast analytics on DynamoDB to enable ad hoc queries in their crypto accounting software service.
Read more
DocumentationHow to use DynamoDB tables as data source
Read up on how to securely connect DynamoDB tables in your AWS account with Rockset and create collections which sync your data in real time.
Read more
Our Customers
See how the most innovative companies do more with their data, faster.
"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."
-Naresh Talluri, product manager at FULL Creative
Read more
