Rockset is a real-time database in the cloud. It builds real-time converged indexes on transactional data from other databases and event data from streams, and supports schemaless ingest, built-in transformations and declarative SQL over REST. It is used for building data applications that make intelligent decisions on real-time data.
Rockset can be used as a backend to power operational dashboards and real-time APIs. The following properties make it well suited for this:
The section below outlines the ways in which you can load data into Rockset. Following that, the other sections outline the ways to query data, and finally ways to access Rockset programmatically via the API.
Rockset manages data ingestion and can continuously sync data from databases, lakes and streams without any ETL pipelines. The data itself can be in different formats such as JSON, XML, CSV, Apache Parquet. Follow the links below to learn more about how to set up an integration with the supported data sources.
If your data is not in any of these sources, or you want to stream events directly into Rockset, you can use the Write API to write data into Rockset. Using one of the supported client SDKs or the REST API, you can stream records in real-time to Rockset to be indexed and turned into fast SQL tables.
If you would like to request support for a new data source, please drop us a note at email@example.com.
You can connect the following visualization and dashboarding tools to Rockset. These tools are fully supported and can natively query Rockset using SQL to build real-time visualizations.
Rockset supports Jetbrains Datagrip if you want to connect to Rockset and compose SQL queries in an IDE. Follow the link below for documentation.
Rockset has client libraries wrapped on top of REST that can be used to insert, update and query data programmatically from custom application code.
We are working on enabling new client libraries. If you would like to get early access to them, contact firstname.lastname@example.org.