Company
Date Published
Author
Bartosz Mikulski
Word count
3248
Language
English
Hacker News points
None

Summary

The article explains how to use Firebolt and Cube to generate insights from Wikipedia page view logs, with the goal of identifying outliers in the data. The process involves creating a Firebolt account, setting up a database and table structure, ingesting data from S3 into Firebolt, calculating time-window aggregations, searching for outliers, and storing the results in a separate fact table. Additionally, Cube is used to encapsulate queries, provide access control, and deliver the data via its REST API to end users of a web application built with React. The article also discusses the technology behind Firebolt's high performance and how it can be connected to Cube for a seamless data analytics experience.