Semi Structured Analytics

If you’re trying to query semi-structured data, you’re probably spending a lot of time on flattening/unnesting/exploding. Whatever you call it, it’s wasting your time and budget. Flattening a table multiplies the number of rows with the number of cells in the arrays and as a result you end up with a much bigger table, more unnecessary costs and painfully slower performance.

Firebolt enables you to run SQL queries directly on semi-structured data with native array manipulation functions, and without compromising speed and efficiency. Read the full semi-structured analytics whitepaper (no form required :)).

Load semi-structured data without having to transform it

JSON manipulation functions are used to seamlessly cleanse, fix and organize semi-structured data as it’s ingested through Firebolt’s pipeline.

Automatically convert semi-structured data to make it ready for querying

Semi-structured data is automatically converted and stored as arrays of primitive types. Users query the data extremely fast with native array manipulation functions while using standard SQL.

Leverage native structured data storage and functions with Firebolt speed

Firebolt provides extreme performance across structured and semi-structured data, regardless of the amount of attributes and arrays it contains