Try our new research platform with insights from 80,000+ expert users

Firebolt vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Apr 17, 2024

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

Firebolt
Ranking in Cloud Data Warehouse
15th
Average Rating
9.0
Reviews Sentiment
7.1
Number of Reviews
1
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Cloud Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
99
Ranking in other categories
Data Warehouse (1st), AI Synthetic Data (3rd)
 

Mindshare comparison

As of April 2025, in the Cloud Data Warehouse category, the mindshare of Firebolt is 0.4%, up from 0.4% compared to the previous year. The mindshare of Snowflake is 20.5%, down from 22.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Iqbal Hossain Raju - PeerSpot reviewer
Can quickly query it to generate quick results
We have used Snowflake before. We support both. Firebolt has better performance, executing queries much quicker than Snowflake. However, Snowflake has more functionality. Depending on the client's needs, we can recommend the best option. Firebolt is a relatively new technology. Snowflake has many functionalities. Firebolt does not support unloading data to S3. There is no built-in way to do this in Firebolt. Alternatively, the data can be retrieved using API calls and loaded to S3 manually. Data can be unloaded to S3 directly using Snowflake. Firebolt significantly improves our performance over Snowflake because it takes less time to execute queries. This is especially important for our company because we use some KPIs that require fast loading times.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

Quotes from Members

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

Pros

"Firebolt is fast for analytical purposes. For example, we have analytical data in our data warehouse, and Firebolt can quickly query it to generate quick results."
"Great scalability and near zero maintenance."
"The solution speeds up the process of onboarding."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"For us, the virtual warehousing is likely the most valuable aspect."
"The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."
"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
 

Cons

"Firebolt's engine takes a long time to start because it needs to make engine calls."
"This solution could be improved by offering machine learning apps."
"In future releases, it can also support full unstructured data."
"We would like to see more security including more masking and more encryption at the database level."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"More data governance and access control features would be a welcome addition."
"Its transaction application needs improvement."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
 

Pricing and Cost Advice

Information not available
"You pay based on the data that you are storing in the data warehouse and there are no maintenance costs."
"The solution is costly, making it unsuitable for midsize organizations due to its price."
"I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production."
"Snowflake’s pricing is transparent. It is one of the cheapest cloud database warehouse providers. The tool follows a credit cost model. Everything on Snowflake is charged on the basis of credits. The credits depend on the cloud region and the public cloud provider that we use. Hence, the cost per credit will be different for AWS in Frankfurt and AWS in India. I think North Virginia is the cheapest region in terms of cost per credit. You will be consuming around 16 credits for large data warehouses."
"The price for the solution's license depends on the use cases."
"I have not been billed yet, but it should be less. I'm still running the trial version, but it seems to be less than Databricks."
"It's expensive."
"Part of the problem with the pricing is that it is very difficult for businesses to get an idea of how expensive it might be until they actually start using Snowflake."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Educational Organization
40%
Financial Services Firm
12%
Computer Software Company
8%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Firebolt?
Firebolt is fast for analytical purposes. For example, we have analytical data in our data warehouse, and Firebolt can quickly query it to generate quick results.
What needs improvement with Firebolt?
Firebolt's engine takes a long time to start because it needs to make engine calls. Currently, the data size of Firebolt is small. It can be increased.
What advice do you have for others considering Firebolt?
One way to retrieve data from firewalls is to add query parameters to the connection string. For example, you can use the REST API to retrieve the security query. Some firewalls have been deployed ...
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
Snowflake's pricing is on the higher side, rated as eight out of ten. If there were ways to reduce costs, it would be a positive improvement.
What needs improvement with Snowflake?
Cost reduction is one area I would like Snowflake to improve. The product is not very cheap, and a reduction in costs would be appreciated.
 

Comparisons

No data available
 

Also Known As

No data available
Snowflake Computing
 

Overview

 

Sample Customers

Information Not Available
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: March 2025.
845,040 professionals have used our research since 2012.