Rockset is a real-time analytics solution which enables database manipulations on massive semi-structured data without operational burden. Rockset supports the following actions:

    • Low latency search
    • Aggregations
    • Joins

    Rockset automatically indexes and can perform search and analytics on your data at scale, in real-time. Your data can be one of the following types:

    • Structured
    • Semi-structured
    • Geo
    • Time-series


    Overview Diagram

    The Loading Data section explains how to connect, transform, and ingest your various data sources into Rockset.

    The Querying section details how to write SQL queries on Rockset and work with Rockset's flexible schemas.

    The Performance and Scaling section describes how to scale Rockset with your application by increasing the compute resources available, to serve your queries.

    The Applications and Dashboards section describes how to build Rockset-backed applications by exposing REST endpoints to execute SQL queries, monitor your resource usage and performance, and create live dashboards that can integrate with various visualization tools.

    The Administration section describes how to enable access and security, view audit logs, and track account activity. This section also describes Rockset's data encryption policies.

    Data Sources

    Rockset has pre-built native integrations for several external data sources. Once connected, Rockset automatically loads your data within seconds, so you can immediately begin to create SQL queries. The data itself can be in different formats such as JSON, XML, CSV, or Apache Parquet.

    Managed integrations for the following data sources are currently supported:

    If your data is not in any of these sources, or you want to stream events directly into Rockset, you can always use the Write API directly to write data to your Rockset collections. To request support for a new data source, please drop us a note at

    Developer Tools

    API Access

    Rockset has several client libraries which wrap the Rockset API. The client libraries can be used to programmatically insert, update, and query data from your application's code:

    We are working to enable new client libraries. If you would like to get early access to them, contact

    IDE Support

    If you want to use Rockset and compose SQL queries inside your IDE, Rockset supports Jetbrains DataGrip and VS Code:


    If you’re having trouble finding what you’re looking for or still have any questions for us, please contact us at