How to Implement Change Data Capture for MySQL and Postgres
Nov 15, 2021 · For this example, whenever an update command is detected to a row in our source table, we want to trigger another update on the affected row which sets the update timestamp to the current …
What Do I Do When My Snowflake Query Is Slow? Part 2: Solutions
Feb 14, 2022 · We’ll cover Snowflake performance tuning, including reducing queuing, using result caching, tackling disk spilling, rectifying row explosion, and fixing inadequate pruning.
Diagnosing Slow Snowflake Query Performance | Rockset - Medium
Jan 27, 2022 · To avoid a row explosion, ensure the query result does not contain more rows than all its inputs combined. Similar to the query pattern, using joins is in the hands of the developer.
Change Data Capture: What It Is and How to Use It - Medium
Jun 21, 2021 · Similar to the row versioning solution, every time a record in the database changes you update a column.
How Rockset’s Converged Index Powers Real-Time Analytics
Dec 24, 2020 · The Rockset Converged Index is the combination of a row index, a columnar index and a search index built on top of a key-value store abstraction. Rockset uses RocksDB, but any key-value …
Distributed Aggregation Queries — A Rockset Intern Story
Aug 9, 2019 · For each row in the table, we create three hash keys, one for each grouping. A hash key is generated by hashing together an identifier for which grouping it corresponds to and the values of …
Real-Time Analytics Using SQL on Streaming Data with Apache
Aug 1, 2019 · This post offers a how-to guide to real-time analytics using SQL on streaming data with Apache Kafka and Rockset.
Rockset - Medium
Jul 16, 2019 · Rockset, the Real-Time Analytics Platform Built for the Cloud, delivers fast analytics on real-time data with surprising efficiency.
Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries
Sep 24, 2019 · Rockset is built on three types of indexes - columnar storage, row storage, and a search index. We store each of the indexes in RocksDB, an ordered key-value store.
Rockset – Rockset – Medium
Read writing about Rockset in Rockset. Rockset, the Real-Time Analytics Platform Built for the Cloud, delivers fast analytics on real-time data with surprising efficiency.