We performed a comparison between Amazon Redshift and Firebolt 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."Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"It is very easy to dump data into the tool."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"This service can merge and integrate well with all databases."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"The most valuable feature of Redshift is its cluster."
"The ability to reload data multiple times at different times."
"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 customer support could be more responsive."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The explain panel in the Redshift database could be better."
"The OLAP slide and dice features need to be improved."
"The product could be improved by making it more flexible."
"The solution could improve in handling more data formats and more native support for RDF."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Firebolt's engine takes a long time to start because it needs to make engine calls."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Firebolt is ranked 14th in Cloud Data Warehouse with 1 review. Amazon Redshift is rated 7.8, while Firebolt is rated 9.0. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Firebolt writes "Can quickly query it to generate quick results". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, whereas Firebolt is most compared with Snowflake, Microsoft Azure Synapse Analytics and Yellowbrick Cloud Data Warehouse.
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.