Real-Time Upserts

Keep your business in motion

Ingest upserts into your real-time analytics database for accurate, up-to-date business insights.

Masthead

Business metrics that never get old

Updates Inserts

Make updates and inserts, without legwork

Freshest Data

Trust that your data is
always fresh

Bolt Power

Power your real-time analytics application

Perform upserts for millions of rows per second

Unlock timely and accurate insights from your data in motion and power your real-time analytics application.

Deletes

Remove obsolete data from your database that you don’t want to see in future queries. Once our real-time engine encounters a record with a delete column, the primary key will no longer be part of queryable documents — saving you headaches.

Deletes

Partial upserts

Update some of the fields in a record, but not all of them. Partial upserts enable flexible handling of data streams with partial information — perfect for Change Data Capture (CDC) streams where only updated columns are received.

Partial Upsets

Compaction

Minimize disk space and overall infrastructure costs by periodically replacing obsolete records in your database with newer compacted segments that only contain valid records.

Compaction

Configurable comparison column

Select a different time column for resolving upserts, rather than using the default. Perfect for when you need to prioritize records based on a different timestamp — not the most up-to-date record.

Comparison

Bootstrap and backfill

Efficiently bootstrap (initialize) and backfill (update past data) into an upsert-enabled table, using a batch data pipeline to directly upload segments.

Bootstrap
Amberdata Logo White

“The benefits of migrating to StarTree and Pinot center around three areas: query performance, SLAs, and cost. With Pinot, we are now in the subseconds to milliseconds range, the higher query concurrency means we can serve more customers faster, and we’ve been able to reduce our infrastructure costs.”

Amberdata Joanes Espanol
Joanes Espanol
CTO and Co-Founder

Ready to deploy real-time analytics?

Start for free or book a demo with our team.