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 :)).
JSON manipulation functions are used to seamlessly cleanse, fix and organize semi-structured data as it’s ingested through Firebolt’s pipeline.
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.
Firebolt provides extreme performance across structured and semi-structured data, regardless of the amount of attributes and arrays it contains