No more typing reviews! Try our Samantha, our new voice AI agent.

CloudQuery vs StreamSets comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

CloudQuery
Average Rating
9.0
Reviews Sentiment
6.4
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (22nd)
StreamSets
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
21
Ranking in other categories
Data Integration (27th)
 

Featured Reviews

MR
Cloud Security Support at a tech vendor with 501-1,000 employees
AI-driven queries have transformed how I discover hidden cloud assets and misconfigurations
One of the improvements that could be made to CloudQuery is the GUI. In the past, I had issues where I couldn't see all the information that would pop up at the bottom. That might be fixed by now, but I was experiencing issues with the GUI itself. CloudQuery's AI capabilities lack governance and security features. While the AI is great for helping me craft SQLs to find assets in the environment, it does not have real security features for blocking or similar tasks. I can set up SQLs for alerting, but I find that a bit limiting. For what it is, CloudQuery is great. The only improvement I could suggest would be to set up more alerting features, but overall it is great for what it is, and I would say it feels a little bit limiting.
SS
Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees
Enables effective batch loading with visual interface and enterprise support
One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infrastructure. I had to switch to a new EC2 box, even though the processor was not fully utilized. It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades. Additionally, it would be a great enhancement if StreamSets could produce a lineage graph to visualize how the data has passed through the system.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The AI-generated SQL works well for my team as it gets things right most of the time."
"CloudQuery has positively impacted my organization because instead of navigating through multiple cloud consoles, I can run an SQL query and get, for example, all my S3 buckets that are public, private, or that I need to do something with."
"In StreamSets, everything is in one place."
"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."
"The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."
"It is really easy to set up and the interface is easy to use."
"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."
"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"
"This product was a lot easier to use than the one we had before it, and it took us half an hour and we were set up and running it the first time."
"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."
 

Cons

"CloudQuery really acts as an asset inventory tool, which is great, but I find that somewhat limiting."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"There are a few things that can be better."
"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."
"If the data processing in StreamSets takes a long time as compared to the previous solution, then we will reconsider why we use StreamSets."
"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."
 

Pricing and Cost Advice

Information not available
"The pricing is affordable for any business."
"It's not so favorable for small companies."
"StreamSets is an expensive solution."
"It has a CPU core-based licensing, which works for us and is quite good."
"I believe the pricing is not equitable."
"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."
"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."
"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
10%
Outsourcing Company
9%
Comms Service Provider
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise2
Large Enterprise2
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise11
 

Questions from the Community

What needs improvement with CloudQuery?
CloudQuery could maybe integrate with some AI agents like ChatGPT or Claude to help us do some things like writing in natural language instead of SQL. Regarding CloudQuery's AI capabilities, I thin...
What is your primary use case for CloudQuery?
My main use case for CloudQuery is as a tool for inventory platforms that lets me extract, transform, and query infrastructure data using SQL. A quick specific example of how I use CloudQuery in my...
What advice do you have for others considering CloudQuery?
My advice to others looking into using CloudQuery is that if you like SQL, you can use this product as if it was MySQL, SQL Server, or any other relational database. I would rate this product a 10 ...
What needs improvement with StreamSets?
One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infr...
What is your primary use case for StreamSets?
We are using StreamSets for batch loading.
What advice do you have for others considering StreamSets?
If asked, I definitely recommend StreamSets to other users. My overall rating for the solution is nine.
 

Overview

 

Sample Customers

Information Not Available
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: September 2026.
915,341 professionals have used our research since 2012.