DataSketches functions
Apache Datasketches is a library designed to efficiently summarize and analyze large-scale data using probabilistic data structures known as sketches. These sketches provide approximate answers to complex queries, such as distinct counting, quantile estimation, and frequency estimation, with high accuracy and significantly reduced memory usage. This makes Datasketches ideal for big data applications where traditional exact methods are impractical due to time or space constraints.
JSON functions
Extract and transform JSON into Firebolt native types, or JSON sub-objects. Used either during the ELT process or applied to columns storing JSON objects as plain TEXT.
Numerical functions
Manipulate data types including INTEGER, BIGINT, DOUBLE PRECISION, and other numeric types.