Yes you can.
Firebolt’s unique indexing strategies coupled with highly scalable compute allow you to query directly against highly granular data. So there’s no need for secondary transformations.
Yes you can.
Using a proprietary optimized storage format with indexing built into it, the data your queries are looking for can be found with dramatically less data scans, reducing query runtimes significantly. This ensures speed and cost efficiency even for scale and high granularity.
Yes you can.
At Firebolt, we believe joins aren't a luxury, they should be a commodity. Highly normalized structures should be a first class citizen. You can spend your time developing solutions that provide value, rather than wasting time denormalizing for a platform that can't perform without it.
Yes you can.
Firzebolt’s ability to analyze TB+ scale data in sub-seconds, while keeping hunger for CPU low, means that a single cluster can easily handle hundreds of concurrent queries. If the workload increases, just scale your engines.
Yes you can.
With Firebolt’s advanced JSON and array functions, Firebolt has the capacity to index by values nested deep inside JSON objects. You can have the best of both worlds, flatten out json elements into individual columns on ingest, or load entire json elements into a column and index where appropriate