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.

Key Benefits

10-15x

More data in memory compared to NoSQL databases

50k

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

100x

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

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
Upsolver Lookup Tables
SCHEDULE A FREE DEMO

Key Benefits and Feature Highlights

Fully Secure

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

Elastic Scaling

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

Shockingly Easy

Easy to create without ETL coding or IT management using aself-service UI and UpSQ

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
GET A DEMO

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
window aggregations
GET A DEMO

Simple REST API

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
GET A DEMO

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

Get webinar recording »

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

data lake ETL Demo

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