Rockset is a serverless search and analytics engine that can be used to build analytics dashboards and APIs on TBs of data. It turns data in databases and streams into highly performant SQL tables without requiring schemas, structural transformations or pipelines.
With Rockset as a backend, you can power:
Rockset can be used as a backend to power operational dasboards 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 firstname.lastname@example.org.
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 email@example.com.