Rockset Reviews & Product Details

I really liked the interface and the suggestions that we will get when writing the query. Mostly I liked the cache part, when we can get the results in milli seconds if the query is already executed. Review collected by and hosted on G2.com.

The app is not available in mobile version. Some times when there is production issue and I wanted to execute something in mobile because im out of office, we can't open it in mobile ro execute the query and send to teammates. Review collected by and hosted on G2.com.

- Let's us dream bigger - adding analytics / reporting features to our product is a breeze with Rockset

- Incredibly easy to set up and get started

- Queries just work and are pretty fast out of the box

- Customer Support has been fantastic, team has been very supportive even of a "small fish" like us

- Very stable even in their "shared" environment, "rock"-solid consistency and uptime Review collected by and hosted on G2.com.

For a small operation like hours, the cost of dedicated instances is pretty high (~$250/month), and we can't take advantage of amazing features like ingest isolation or query autoscaling without hitting this bar. The "Milli" shared instance experience has been fine for us so far, but I can always dream of more.

The SQL editor was ahead of its time in 2022 but now writing SQL in 2024 without AI copilot feels like a chore!! Review collected by and hosted on G2.com.

I've been using Rockset for a few years now and I'm honestly suprised at how few issues I've had with it. I basically set it up and have barely had to check-in on it which is very impressive. Myself and the other engineers really like the query lambda function and how they are version controlled. It's also very fast and able to handle many queries at the same time which our data warehouse isn't built to do. We use it to compliment our data warehouse for embedded analytics for our customers. Customer support has been awesome as well. Review collected by and hosted on G2.com.

Not a dislike but I want to make clear that I don't believe Rockset is a replacement for a traditional data warehouse. Instead, I believe it would replace setting up a streaming architecture with tools like Kafka or Kinesis. The only thing I can say is I wish you didn't have to be on a certain tier to get autoscaling capability. Review collected by and hosted on G2.com.

The product is very good. The queries are fast, the API is mature and growing, features such as the Query Lambdas are fantastic and integration options are solid. Above all, the service and assistance from the Rockset team is fantastic, they hold regular meetings and provide valuable technical assistance to optimizing queries and storage to tweek further the performance. Review collected by and hosted on G2.com.

The only downside is the compute model and pricing. We pay for a dedicated instance while most of the time there are no queries being executed. Having a compute model similar to Serverless or something where you actually pay for what you use would be fantastic. Review collected by and hosted on G2.com.

Rockset is easy to set up and configure. There is no need to set up manual indexes or any of that complicated database mumbo jumbo to get rockset to go FAST. Scaling vertically is very easy and fast all you need to do is select a larger virtual instance size and the database scales up instantly. Rockset support is also exceptional and helped me regularly understand best practices while using rockset and how to get the most out of my rockset cloud instance subscription.

I use rockset every day at work. working with their query lambdas and using the rockset api through the javascript sdk makes it easy to integrate it with other systems. Their native support for kafka streams and realtime transformations from the same makes it very easy to ingest large datasets from realtime sources. Review collected by and hosted on G2.com.

Although rockset it very simple to operate, if you have very specific requirements that need you to do highly optimized queries on a table, it doesnt have the flexibility to optimise for that. This is really a nit pick, I personally think it is good for most OLAP use cases right out of the box. Review collected by and hosted on G2.com.

I've been using Rockset for over a year now, and things that have worked well for me are the user-interface, the creation of sql queries and the scalability when there are heavier queries.

I've reached out to customer support twice, and they've been prompt and helpful. I've also not experienced any downtime in my working hours which is great product stability wise

My overall experience has been great Review collected by and hosted on G2.com.

I have a limit on the number of queries i can create with the version being used for my company, I guess thats a limitation Review collected by and hosted on G2.com.

I have been using Rockset for data visualization in my daily SQL consulting tasks, and overall, it has proven to be a powerful and efficient tool for my needs. The platform's seamless integration with SQL queries has significantly enhanced my ability to analyze and visualize data, making it an invaluable asset in my day-to-day job. The customer support provided by Rockset is commendable, particularly the quick and responsive assistance available via chat. Having reliable and efficient customer support is crucial in ensuring that any issues or queries are addressed promptly, and Rockset delivers on this front. Review collected by and hosted on G2.com.

There are a few SQL functions that are not currently supported by the tool. While the existing capabilities cover a broad range of functions, the absence of certain SQL functions may pose limitations for users with specific requirements. It would be beneficial for Rockset to prioritize expanding its support for a wider array of SQL functions to cater to the diverse needs of users. Review collected by and hosted on G2.com.

- Rockset has a great developer tooling with query lambdas, a robust API and metrics/charts to understand performance.

- The fact that it automatically indexes everything in 3 different ways saves a ton of time for us that we'd otherwise need to spend building indexes ourselves.

- has great additional commands to complement standard sql like UNNEST

- Engineers and Support at Rockset are very helpful in answering any questions that may come up and are always willing to jump on a call to debug performance or discuss an issue Review collected by and hosted on G2.com.

- Definitely needs a tree view for looking at data and especially nested data so one doesn't need to scroll horizontally as much Review collected by and hosted on G2.com.

We do not have to transform our denormalized document data into a normalized state for relational databases. We can pass our single-table design Dynamo tables straight into Rockset, with a minimal time delay (usually 1-2 seconds), and then do complex SQL queries. Review collected by and hosted on G2.com.

Our document structure sometimes needs a sub-object to be returned. It would be great if we can simply do "SELECT OBJECT(t1.*) as subObject ..." instead of typing every single field that we need in the sub-object. Review collected by and hosted on G2.com.

There are quite a few -

- Sub second queries even for nested schemaless json

- No need for data modelling and strict schemas

- Data can be easily mutable

- Data accesible over apis with query lambdas

- Very abstracted so that I dont need to think about optimizations

- Really awesome customer support Review collected by and hosted on G2.com.

- Scheduled based autocaling

- Ability to switch ingest VIs

- Priority based queries queuing Review collected by and hosted on G2.com.