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."It is quite simple to use and there are no issues with creating the tables."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"It is very easy to dump data into the tool."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The processing of data is very fast."
"Easy to build out our snowflake design and load data."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"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."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The product must become a bit more serverless."
"Running parallel queries results in poor performance and this needs to be improved."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"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, Snowflake, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, 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.