What do you like best about the product?

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 the product?

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 the product 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.