DynamoDB Analytics in Amazon Redshift

Stream DynamoDB data to Redshift for fast, cost-effective analytics. Combine with other AWS data sources for a complete data warehouse.

Start free →
The Problem

DynamoDB is optimized for single-item lookups at massive scale — not for running aggregation queries across entire tables. Running a Scan operation on a large DynamoDB table is slow, expensive (consumes RCU), and can throttle your application. Your data team needs the data in Redshift for proper analytics, but building and maintaining a DynamoDB → Redshift pipeline is non-trivial.

The Solution

NoSQLSync connects to your DynamoDB table via DynamoDB Streams and continuously replicates data to Redshift. Every Put, Update, and Delete event flows to Redshift tables. Your data team queries using standard SQL in Redshift Spectrum or Redshift native tables — fast, cheap, and without impacting DynamoDB performance.

Key Benefits

SQL analytics on DynamoDB data

Query DynamoDB data using full SQL: JOINs, aggregates, window functions, CTEs — all the power of PostgreSQL-compatible Redshift.

No more expensive DynamoDB Scans

Stop running table scans for analytics. Scan operations on large tables can cost hundreds of RCU per query. Redshift queries are predictable and cost-effective.

Combine with other AWS data

Join DynamoDB data with RDS data, S3 data (via Redshift Spectrum), and data from other AWS services for a complete data warehouse.

DISTKEY and SORTKEY optimization

NoSQLSync maps your DynamoDB partition and sort keys to Redshift DISTKEY and SORTKEY — optimizing query performance from day one.

Separate compute and storage

With Redshift RA3 nodes or Serverless, compute and storage scale independently. Keep months of DynamoDB history for trend analysis.

How to set it up

1
Enable DynamoDB Streams
Make sure DynamoDB Streams is enabled on your table (NEW_IMAGE or NEW_AND_OLD_IMAGES). NoSQLSync reads from the stream.
2
Connect Redshift
Point NoSQLSync to your Redshift cluster or Serverless endpoint. It provisions tables with optimal DISTKEY and SORTKEY settings.
3
Start sync
Historical data loads via parallel Scan operations (with rate limiting). Ongoing changes stream via DynamoDB Streams with sub-second latency.

Frequently asked questions

Does this affect my DynamoDB provisioned capacity?

NoSQLSync's bulk load uses parallel Scans with configurable RCU limits to stay within your provisioned capacity. CDC uses DynamoDB Streams, which are priced separately and don't consume table RCU.

How do DynamoDB types map to Redshift?

String → VARCHAR, Number → NUMERIC, Binary → VARBYTE, Boolean → BOOLEAN, List → SUPER (JSON array), Map → SUPER (JSON object), String Set / Number Set → SUPER. You can customize all mappings.

Solve your migration challenge today

Free plan includes 3 migrations per month. No credit card required.

Start free →