We performed a comparison between Firebolt and Microsoft Azure Synapse Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."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 product is easy to use, and anybody can easily migrate to advanced DB."
"It is a fantastic product; we are satisfied with its features and performance."
"The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"They are very reliable and cost-effective."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"Firebolt's engine takes a long time to start because it needs to make engine calls."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"It's a complicated product."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"Integration with other products is an area that can be improved."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Firebolt is ranked 14th in Cloud Data Warehouse with 1 review while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews. Firebolt is rated 9.0, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of Firebolt writes "Can quickly query it to generate quick results". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". Firebolt is most compared with Snowflake, Yellowbrick Cloud Data Warehouse and Amazon Redshift, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.