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's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The most valuable feature is the scalability, as it grows according to our needs."
"The product is relatively easy to use because there is no indexing and no partitions."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Easy to build out our snowflake design and load data."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"It is quite simple to use and there are no issues with creating the tables."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"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."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"It lacks a few features which can be very useful, such as stored procedures"
"Infinite storage is available in Snowflake and is not available in Redshift."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"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 58 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 AWS Lake Formation, Snowflake, Teradata, 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.