Rockset

    Home

    Rockset is a real-time analytics database which enables queries on massive, semi-structured data without operational burden. Rockset is serverless and fully managed. It offloads the work of managing configuration, cluster provisioning, denormalization, and shard / index management. Rockset is also SOC 2 Type II compliant and offers encryption at rest and in flight, securing and protecting any sensitive data. Most teams can ingest data into Rockset and start executing queries in about 15 minutes, depending on the amount of data ingested.

    With Rockset, ingested data is queryable after 1-2 seconds and analytical queries against that data typically execute in milliseconds. Via Rockset’s Converged Index(™), all data is automatically indexed three ways - column, row, and search - at the time of ingestion. The SQL query optimizer examines each query and chooses an execution plan for optimal performance. You will typically see query executions in the 100s of milliseconds on fresh data. Rockset is compute optimized, making it suitable for serving high concurrency applications in the sub-100TB range (or larger 100s of TBs with rollups). It’s not a data warehouse and is not suitable for occasional queries on a PB-scale dataset.

    Rockset supports schemaless ingest for the following data types:

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

    Rockset has managed integrations for the following external data sources:

    • Amazon DynamoDB
    • Amazon Kinesis
    • Amazon S3
    • Apache Kafka
    • Google Cloud Storage
    • Microsoft Azure Blob Storage
    • Microsoft Azure Event Hubs
    • Microsoft Azure Service Bus
    • Microsoft SQL Server
    • MongoDB
    • MySQL
    • Oracle
    • PostgreSQL

    Rockset can follow CDC streams from both RDBMS and NoSQL data stores. Additionally, it supports complex, analytical rollups for both Amazon Kinesis streams and Apache Kafka streams. You can also use Rockset’s REST API to integrate with any of your data sources or stream inserts in real time.

    Rockset automatically generates a schema on your data. This enables SQL queries over data sources that don't natively support SQL. Rockset supports:

    • Aggregations
    • Filtering
    • Windowing
    • Joins

    All features are available on all fields, including heavily nested objects and arrays, on any semi-structured data. This enables SQL queries over data sources that don't natively support SQL. See the SQL Reference page for the full list of all functions available.

    Rockset is free to try.

    Overview

    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 support@rockset.com.

    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 support@rockset.com.

    IDE Support

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

    Questions?

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