Company
Date Published
July 3, 2024
Author
Stephen Kallianos, Ben Paul
Word count
805
Language
English
Hacker News points
None

Summary

SingleStore's Job Service allows users to schedule notebooks on a time-based schedule to repeatedly update tables with aggregated data, similar to Rockset's scheduled query lambdas. To achieve this, users create a notebook that uses Table-Valued Functions (TVFs) and executes them via SingleStore's Data API. The TVF queries the desired table, and the results are then inserted into another table. Users can schedule these notebooks using the Job Service to run at specific frequencies, such as once an hour, to maintain up-to-date aggregated data in their database. This functionality is useful for tasks like data preparation, ML flows, transforms, caching results, sending automated alerts, ingesting data from various sources, and creating and managing workspace groups.