We just raised a $30M Series A: Read our story

Firebolt Competitors and Alternatives

Get our free report covering Snowflake Computing, Amazon, Microsoft, and other competitors of Firebolt. Updated: September 2021.
542,029 professionals have used our research since 2012.

Read reviews of Firebolt competitors and alternatives

RAHULVERMASIR
Technical Architect at a computer software company with 501-1,000 employees
MSP
Top 10
Great performance, good technical and community support, and resizable according to your needs

Pros and Cons

  • "Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
  • "There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."

What is our primary use case?

We are using it for a migration from on-prem to cloud.

What is most valuable?

Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake. 

What needs improvement?

There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it.

For how long have I used the solution?

It has been almost two years.

What do I think about the scalability of the solution?

A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.

How are customer service and technical support?

We have contacted them only for the basic setup. Most of the time, we were able to get the right solution at the right time. We got great support from them.

They're doing a pretty great job in providing all the information. They have a great community and great coverage, and there is a lot of information available over the internet.

How was the initial setup?

Its setup was quite straightforward. I did not find any complexity with that.

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down.

I would rate Snowflake an eight out of 10.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
AP
Data Architect at a tech services company with 51-200 employees
Real User
Top 20
Good support, offers advanced threat protection, and it integrates well with Polybase

Pros and Cons

  • "The most important feature for me is the integration with PolyBase."
  • "The need to improve a little bit in terms of user-friendliness."

What is our primary use case?

We are mainly using this solution as an interface between the Data Lake and the users.

We are consultants and this product assists with the services that we offer for our clients. Our company has a large number of consultants who are working in this space.

What is most valuable?

The most important feature for me is the integration with PolyBase.

Other valuable features for me are advanced threat protection and data privacy.

What needs improvement?

I would like there to be more focus on the Software as a Service (SaaS) product. For example, Snowflake, one of their competitors, is more focused on SaaS.

They need to improve a little bit in terms of user-friendliness. I would rate them a three out of five, in terms of how user-friendly the interface is.

The auto-scaling capabilities are quite poor, especially compared to Snowflake or Firebolt.

For how long have I used the solution?

In total, I have been using Microsoft Azure Synapse Analytics for one year.

What do I think about the stability of the solution?

This is a stable solution.

What do I think about the scalability of the solution?

You can scale it, although you need to put in more effort. We have approximately 800 users.

How are customer service and technical support?

In general, Microsoft support is pretty good.

Which solution did I use previously and why did I switch?

I have experience with similar products such as Snowflake and Firebolt.

How was the initial setup?

The initial setup is very complex compared to other products. It takes weeks to deploy.

What about the implementation team?

We implement this product for our clients.

What's my experience with pricing, setup cost, and licensing?

The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte. The charge might be several thousand dollars or more each month.

There are multiple options that are available at an extra cost. For example, the advanced threat protection costs an extra $25 USD.

Which other solutions did I evaluate?

We evaluated several options before choosing Synaps Analytics.

What other advice do I have?

The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Get our free report covering Snowflake Computing, Amazon, Microsoft, and other competitors of Firebolt. Updated: September 2021.
542,029 professionals have used our research since 2012.