Data Warehouses

Time Value of Data: The Summit of Now and the Peak of Soon After

by Serhii Sokolenko
April 2, 2023February 21, 2024

Last week I had the chance to visit a major global fashion retailer and give an industry talk on Real-time AI. This company was hosting… Read More »Time Value of Data: The Summit of Now and the Peak of Soon After

How to speed up your BigQuery query 31x by replacing a self-join with two UNNEST() operations

by Serhii Sokolenko
July 9, 2017September 18, 2021

One of my trend calculation queries in the Opinion Analysis project started causing trouble recently. It would run for 270 seconds and break with an… Read More »How to speed up your BigQuery query 31x by replacing a self-join with two UNNEST() operations