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."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"Everything is automatic, and I don't have to do any maintenance."
"The speed of data loading and being able to quickly create the environment are most valuable."
"The querying speed is fast."
"The solution's computing time is less."
"This solution has helped our organization by being easy to maintain and having good technical support."
"Very easy to use and easy to query."
 

Cons

"Firebolt's engine takes a long time to start because it needs to make engine calls."
"There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"The addition of more AI capabilities in Snowflake would help us more."
"The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
"The product's performance could be improved."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility."
 

Pricing and Cost Advice

Information not available
"Its price should be improved. It should be cheaper than Microsoft."
"The price of Snowflake is quite reasonable."
"The price of Snowflake is very reasonable."
"The price of the solution is reasonable."
"Pricing is based on usage. It is the most expensive of our data tools."
"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."
"We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
"Snowflake is a cost-effective solution."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
844,944 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.
844,944 professionals have used our research since 2012.