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 of Amazon Redshift is its ability to handle really large sets of data."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The most valuable feature is its scalability."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"It allows you write complex queries and perform row by row processes."
"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."
"Sometimes, it's difficult to get the metadata from Redshift."
"In our experiments, the handling of unstructured data was not very smooth."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"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."
"The OLAP slide and dice features need to be improved."
"There are too many limitations with respect to concurrency."
"Should be made available across zones, like other Multi-AZ solutions."
"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.