# Firebolt Reviews **Vendor:** Firebolt Analytics **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.5/5.0 **Total Reviews:** 14 ## About Firebolt Firebolt's Cloud Data Warehouse delivers extreme speed and elasticity at any scale solving your impossible data challenges. Its unique technology combines the best of high performance database architecture with the infinite scale of the data lake, enabling you to perform analytics at jaw-dropping speed across terabyte and petabyte scale. Built on a decoupled storage and compute architecture, Firebolt allows you to easily scale up or down to support any workload. ## Firebolt Pros & Cons **What users like:** - Users commend the **robust analytics capabilities** of Firebolt, enabling quick integration and high performance for daily usage. (2 reviews) - Users praise the **ease of access** to Firebolt’s functionalities, streamlining workflow and enhancing productivity effortlessly. (2 reviews) - Users praise **Fast Querying** in Firebolt, enabling lightning-fast report generation and seamless integration for diverse data sets. (2 reviews) - Users appreciate the **cost-effectiveness** of Firebolt, providing unmatched value without compromising performance or features. (1 reviews) - Users value the **fantastic customer support** of Firebolt, facilitating seamless integration and ongoing improvements. (1 reviews) - Ease of Use (1 reviews) - Easy Setup (1 reviews) - Fast Processing (1 reviews) - Integrations (1 reviews) - Large Datasets (1 reviews) **What users dislike:** - Users find the **difficult setup** of Firebolt cumbersome, hindering efficient workflows and increasing service interruptions. (1 reviews) - Users report experiencing **technical difficulties** with engine bouncing, causing service interruptions and complicating code interactions. (1 reviews) - Users often face **update issues** , leading to service interruptions and complicated workflows due to engine segregation. (1 reviews) - Users find the **UX improvements** in Firebolt lacking, wishing for better API access to stored queries. (1 reviews) ## Firebolt Reviews ### 1. Mind-blowing performance and awesome support **Rating:** 5.0/5.0 stars **Reviewed by:** Max Z. | CTO, Mid-Market (51-1000 emp.) **Reviewed Date:** March 21, 2025 **What do you like best about Firebolt?** We use Firebolt to power our Business Intelligence and Analytics module in our enterprise SaaS app. With our main transactional database being Postgres, and Firebolt being Postgres-API compatible, it was very easy to write the ELT process for the transactional data in our main database to the data warehouse in Firebolt. Our developers are also able to write Firebolt queries with ease, and the aggregate indexes have been extremely helpful at ensuring very fast performance given our reports group on many columns at once. Firebolt is also able to handle a very consistent "trickle ingestion" workflow which is unusual for this kind of use case but the main challenge that we faced when benchmarking other solutions. This way, we're able to ensure data in the data warehouse is never stale and all reports are pulling from the latest. **What do you dislike about Firebolt?** The only thing our team has asked for is for Firebolt to expose live charts on the dashboard to monitor engines CPU, Memory, Query count and other basic statistics, however there are queries that can be run to see this information and this has been an acceptable workaround for now. **What problems is Firebolt solving and how is that benefiting you?** Firebolt tackles our biggest data challenges by handling the millions of rows we need for instant reporting across our enterprise SaaS platform. We're ingesting millions of new rows daily, and frequently running massive updates to our datasets. Before deciding on Firebolt, we benchmarked it against all other major competitors and in most cases it was at least an order of magnitude faster for our queries. What's been game-changing is how Firebolt powers all the reports in our platform without breaking a sweat. This means our customers get the insights they need immediately, without the frustrating wait times they experienced with previous solutions. ### 2. Outstanding speed and features at very reasonable cost, especially the new platform **Rating:** 4.5/5.0 stars **Reviewed by:** Russell G. | VP of Application Engineering, Automotive, Small-Business (50 or fewer emp.) **Reviewed Date:** March 26, 2024 **What do you like best about Firebolt?** **UPDATED: I wanted to update this review to reflect current thoughts especially after migration to the newer platform. Speeds have been markedly improved over the already fast engines that we had been used to. Engines are now multi-purpose. The .Net SDK has been improved dramatically. Support through our platform migration was top notch. Basically all of the great things about Firebolt have been doubled down and made greater. ============================================================ Original review: There are so many things but for starters, it's just how fast we are able to serve up query results to applications and end users regardless of the data set size. Hugely complicated queries run like lightning fast, so much so that we've pivoted from using Firebolt just for reporting and analytics to also including it in our internal tooling for our business. Things we simply couldn't pull off otherwise without a massive scaling of our infrastructure. The cost is simply unmatched for the levels of feature and performance. We're a small company with big ambitions but cost is still a paramount consideration. We have flexibility in controlling our costs and scaling as we see fit, which is great. I've found that my team has generally found the syntax to be pretty easy to pick up, it shares a lot of commonality with other SQL flavors we're familiar with. And even when it stumps us, the documentation is pretty robust (unlike many software vendors we use) and their support staff has been top-notch. They even share a channel in our Slack where we get quick answers to many of our questions. Firebolt goes so far as to proactively watch our query performance patterns and shares that with me and will help us fix them. Simply put, I work WITH Firebolt to solve our problems and limitations instead of working AROUND them like we have to with some other vendors. **What do you dislike about Firebolt?** UPDATED: Specifically, my top dislike listed here has been rectified in the new platform. Engines handle both reads and ingestion/data modification. This has allowed simplification of our code base that interacts with Firebolt as well as reduction of service interruptions. ============================================================ Original review: The segregation of ingestion (or "general purpose") engines from read-only "analytics" engines is great from a granular control mechanism, especially as it pertains to cost. However that often requires bouncing of the read-only engine that services our applications to reflect changes made by the ingestion engine, causing a several minute outage. There are ways around it but this is often the case for us at this time. Additionally, it would be great if there was a way to have stored queries accessible via the API access. Currently the query has to be passed to the API meaning that even where the same query could be used in our code, that is being duplicated and would necessitate an application deployment to make alterations. Compare that to a stored function/procedure model in our sql transaction engine and this is not ideal for a small shop that moves this quickly. **What problems is Firebolt solving and how is that benefiting you?** Firebolt serves us as our data warehouse, our primary ETL processing engine, reporting and analytics platform as well as our high performance query engine for internal tools built for the rest of our organization. ### 3. The Firebolt Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Small-Business (50 or fewer emp.) **Reviewed Date:** March 26, 2025 **What do you like best about Firebolt?** The Fantastic Customer Support, Helping us through out engineering changes and architecture. Observing improvements in the performance every new release. Getting started with Firebolt is very quick. Implementation of Firebolt was simple and quick.We were able to integrate Firebolt for our daily usage. it is used every day for our Analytics. **What do you dislike about Firebolt?** Still undergoing maturity as new features are added everyday **What problems is Firebolt solving and how is that benefiting you?** Processing the data every day and reducing Time to Market in ingesting large chunks of data from multiple suppliers in different formats. ### 4. Noone can beat Firebolt. **Rating:** 5.0/5.0 stars **Reviewed by:** Ashmit M. | Contest Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** April 04, 2023 **What do you like best about Firebolt?** It has great speed and performance. It allows me to handle large datasets and complex queries in a fraction of the time. It also offers a flexible pricing model, which allows me to pay only for the compute resources I actually use. This is very cost-effective for me as I have variable workloads and don't want to pay for unused capacity. **What do you dislike about Firebolt?** I have been using firebolt for quite some time and till now I have enjoyed using it and its interface. As of now I dont think that there is something in Firebolt that I dont like about. **What problems is Firebolt solving and how is that benefiting you?** Traditional data warehouses are often slow and inefficient when it comes to querying and analyzing large amounts of data. But Firebolt solves this problem of mine by using a unique indexing technology and a cloud-native architecture that enables it to deliver fast query performance even on very large datasets.Traditional data warehouses are very expensive to set up and maintain, especially as data volumes grow. Firebolt's cloud-native approach and pay-as-you-go pricing model make it more cost-effective than traditional data warehouses, allowing me to save money while still getting the analytical insights I need. ### 5. Firebolt is Awesome. **Rating:** 5.0/5.0 stars **Reviewed by:** Arushi M. | Siemens Scholar batch -08, Small-Business (50 or fewer emp.) **Reviewed Date:** March 07, 2023 **What do you like best about Firebolt?** It is a cloud data warehouse that offers high performance, scalability, and cost-efficiency, which are some of the most important features that I typically look for in a data warehousing solution. Its unique architecture is built around the use of low-cost storage options, which help me save money on storage costs compared to traditional data warehousing solutions. **What do you dislike about Firebolt?** Firebolt is a relatively new technology, so it does not have the same level of community support or third-party integrations as some more established data warehousing solutions. **What problems is Firebolt solving and how is that benefiting you?** Performance:It is built to handle complex data workloads and execute queries quickly, even on large datasets. This helps me save time and resources by enabling me to process and analyze data more efficiently. Scalability:it is designed to scale horizontally, it adds additional compute resources as needed by me to handle larger workloads. This helps me avoid the need to invest in expensive hardware upgrades or additional data centers to handle increasing amounts of data. ### 6. A cool data warehouse tool! **Rating:** 4.0/5.0 stars **Reviewed by:** Henry C. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 24, 2023 **What do you like best about Firebolt?** - It has an intuitive UI - Its functions are clear and really easy to use. - It has a cool API to send requests when using code - It has customizables engines to adjust them to your budget. **What do you dislike about Firebolt?** - You need to restart an engine to reflect changes made in another engine instantly. Otherwise, you need to wait up to 20 minutes to see your actions reflected. - Currently, it doesn't allow updates on rows of tables. **What problems is Firebolt solving and how is that benefiting you?** We needed a data warehouse to store and connect our data to BI solutions like Metabase. Firebolt so far has been a good solution to our current goals in our business. ### 7. Fastest place to store data **Rating:** 5.0/5.0 stars **Reviewed by:** Daniel L. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 21, 2023 **What do you like best about Firebolt?** I like how fast it is to run queries and retrieve data using Firebolt. It is really good and our performance increase exponentially when we moved our data from on premise to Firebolt. **What do you dislike about Firebolt?** Right now the integration works very well. But I think it would be really good if we are able to seemlessly integrate with many services out of the box with minimal adjustment. **What problems is Firebolt solving and how is that benefiting you?** We use Firebolt to host our data. All of our data was moved from on premise database server to Firebolt could database server. And every day we ran thousands of queries to retrieve data from Firebolt. ### 8. Review - Firebolt **Rating:** 3.0/5.0 stars **Reviewed by:** Vinoth R. | Enterprise (> 1000 emp.) **Reviewed Date:** March 19, 2023 **What do you like best about Firebolt?** The exceptional indexing technology, designed with a focus on security and equipped with data encryption capabilities, delivers outstanding performance. Furthermore, it provides a cost-effective solution that caters to businesses of all scales. **What do you dislike about Firebolt?** The distinct architecture and querying language of Firebolt may necessitate users to acquire new skills and modify their workflows, which could impede the adoption process and act as an obstacle to some organizations. **What problems is Firebolt solving and how is that benefiting you?** Due to its distinctive architecture and optimization techniques, Firebolt can process enormous data volumes and run complex queries at exceptionally fast speeds. ### 9. Fire- Bolt - review **Rating:** 3.5/5.0 stars **Reviewed by:** Haripriya B. | Senior Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** March 14, 2023 **What do you like best about Firebolt?** It boasts exceptional speed and performance, delivering high-quality results at an affordable cost. Its user-friendly interface makes it easy to navigate and operate, even for those with limited technical experience. **What do you dislike about Firebolt?** The steep learning curve is one major dislike about firebolt. Although its indexing technology enables fast querying of data, the platform may face challenges with complex queries. **What problems is Firebolt solving and how is that benefiting you?** Setting up and managing traditional data warehousing solutions can be complicated and require specialized skills and knowledge. In contrast, Firebolt offers a user-friendly interface. ### 10. Firebolt is a great solution for data analysis **Rating:** 5.0/5.0 stars **Reviewed by:** Patrick W. | CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** April 11, 2022 **What do you like best about Firebolt?** Firebolt makes it easy to index and query semi-structured JSON data, as well as import database snapshots, which allows us to aggregate data from many sources to answer questions, generate reports, and explore data. **What do you dislike about Firebolt?** Firebolt could do a better job of explaining the underlying error when querying data from an external data source. When a service error occurs, Firebolt could pass through more information to help identify the source of problems, for example, when network errors or permissions errors arise. **What problems is Firebolt solving and how is that benefiting you?** We want to ingest data from our game services and 3rd-party services providers, along with database snapshots, to generate scheduled automated reports and create explorable data dashboards. We further want to be able to quickly answer ad hoc queries based on summarized data. Firebolt, along with Tableau (for visualization & data exploration) and Prefect.io (for data ingestion and automation), allow us to solve for these requirements. ### 11. Great performance oriented DWH solution **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 12, 2022 **What do you like best about Firebolt?** Firebolt delivers outstanding query speeds, not seen by other DWH solutions. In addition, they provide a very flexible, pay as you go, pricing model. **What do you dislike about Firebolt?** There are still some missing features that are provided by other offers, like other CRUD operations besides SELECT and INSERT or missing RBAC permissions. Since the development of the platform is still very active, I assume these features will be added soon to the product. **What problems is Firebolt solving and how is that benefiting you?** Having tried different data stores for our data needs, we came to Firebolt as our DWH solution, as it offers great support and a very competitive pricing model. It helped us solve the scaling and storage needs for our data sets since we can just push our data into S3 and ingest it easily into firebolt for querying. ### 12. We use Firebolt as our DWH solution to run analytics on a huge data scales **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** November 16, 2021 **What do you like best about Firebolt?** The performance is great on multi-petabyte datasets **What do you dislike about Firebolt?** There are some missing functionalities in the product **What problems is Firebolt solving and how is that benefiting you?** Performance issues when analyzing and querying huge datasets ### 13. Overall satisfying **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 09, 2021 **What do you like best about Firebolt?** Its battery performance and SPO2 sensors. It is awesome product to invest. **What do you dislike about Firebolt?** Its camera shutter feature is complex and couldn't find how to use. And we camnot change volume of musin from watch **What problems is Firebolt solving and how is that benefiting you?** I can get all reminders timely and can recieve every call even if my mobile phone is in silent mode. ### 14. Complicated queries in a speed we never saw before **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** November 04, 2021 **What do you like best about Firebolt?** Complicated queries in a speed we never saw before **What do you dislike about Firebolt?** They still need to work on some bugs and the transition of existing assets **What problems is Firebolt solving and how is that benefiting you?** We don't need to wait anymore for a long query results ## Firebolt Discussions - [What is Firebolt used for?](https://www.g2.com/discussions/what-is-firebolt-used-for) - [View Firebolt pricing details and edition comparison](https://www.g2.com/products/firebolt/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-19+08%3A17%3A37+-0500&secure%5Bsession_id%5D=3ae683e3-468c-43f1-b162-4e1c006e2fb9&secure%5Btoken%5D=a41ac884d9e76ca3102f143d4cc056097fecc00d310a7bef7b48f5592d3dbcf5&format=llm_user) ## Firebolt Features **Data Management** - Data Compression - Data Quality - Built-In Data Analytics - Data Lake Analytics **Integration** - BI Tool Integration - Data lake Integration **Deployment** - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top Firebolt Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (744 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (368 reviews)