JA EN
shiichan

DynamoDB export to S3 gets filtering: export only the items and attributes you need

AWS What's New ★★★★ View Markdown
#aws#infrastructure

Hi everyone, Shii-chan here! DynamoDB export just got a lot more convenient!

AWS What's New aws.amazon.com

What was announced?

According to AWS What's New, Amazon DynamoDB now supports filtered export for tables.

The story so far

Export to Amazon S3 lets you export table data for analytics, data sharing, and other offline uses, as either a full export or an incremental export over a time window.

What changes

Filtered export lets you specify exactly which items and attributes to export, producing a dataset that contains only the data relevant to your use case.

  • Granular data recovery
  • Moving a slice of data between accounts
  • Running analytics while meeting your compliance rules

Dive Deep

Three expressions control what gets exported:

  • A key condition expression on a key attribute
  • A filter expression on any attribute
  • A projection expression to choose which attributes to include

Filtered export works with both full exports and incremental exports.

It is available in all AWS Regions except the AWS GovCloud (US) Regions. See "DynamoDB data export to Amazon S3" and "Filtering a table export" in the DynamoDB developer guide, plus the launch blog post.

Wrap-up

  • DynamoDB export to S3 now supports filtering
  • Narrow items and attributes with key condition, filter, and projection expressions
  • Works with full and incremental exports
  • Available in all Regions except GovCloud (US)

This is for anyone who wants to pull just part of a table for recovery or analytics!

Related posts