<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=315693165909440&amp;ev=PageView&amp;noscript=1">

Upsolver Lookup Tables

The First Indexing Engine for Data Lakes

Query Amazon S3 by any set of keys at high-throughput and milliseconds-latency using a REST API, without the overhead of managing any additional data stores.


more data in memory compared to NoSQL databases


reads per second, per server, at 1ms latency on average


Faster time to production for real-time analytics and machine learning

"Upsolver saved 24 months of engineering that we would have needed to invest to see the same results with Redis or DynamoDB."

Amit Attias, CTO, Bigabid

What are Upsolver Lookup Tables?

Lookup Tables add indexing at high cardinality and performance to your data lake. They enable users to index data by a set of keys and then retrieve the results in milliseconds. Unlike NoSQL alternatives, Upsolver's ETL platform stores indexed data on S3 rather than local servers, which turns IT-intensive cluster management into a non-issue. Lookup Tables leverage break-through compression technology and smart rollups that enable 10X-15X more data in-memory compared to alternatives.

Schedule a free demo and tech discussion »

Key Benefits and Feature Highlights

Reduce 70-90% of infrastructure costs by storing more data in RAM

Decoupled compute and storage for easy healing, scaling, and disaster recovery

Easy to create without ETL coding or IT management using a self-service UI and UpSQL

Query by any set of keys or time range.

Lookup Tables are stored on S3 as a time-series. Using smart rollups, Upsolver makes it possible to query any time range by any set of keys.

Get a Demo

Query S3 by any time window
Upsolver built-in data transformations

Rich library of out-of-the-box window aggregations

Capture real-time behaviour for users and devices, using window aggregations, nested aggregations and time-series aggregations.

Get a Demo


Embed granular user or device data in your applications using a simple REST API and avoid the overhead of additional data stores.

Get a Demo

Upsolver API call example

Use Cases

Embedded Analytics

Serve data in sub-second latency to power real-time dashboards and data-driven apps

Read the Case Study »

Machine Learning ETL

Improve machine learning models and performance by adding user or device-level behavioral features

Watch the Webinar »

Stateful ETL for Stream Data

Perform joins between multiple streaming sources or big tables with a high number of keys.

Read the Case Study »

GDPR and PII Removal

Enforce GDPR and other regulatory compliance by keeping track of all user records in your lake

Let's get personal: See Upsolver on your data in a live demo.

Schedule a free, no-strings-attached demo to discover how Upsolver can radically simplify data lake ETL in your organization.

Get a Demo