sincecutoff.com
← all changes

aws dynamodb ExportTableToPointInTime supports export filters and projections

Introduced 2026-09-30 · score 0.93

HOW TO USE IT

When exporting selected DynamoDB data, pass the expressions inside `--filter-specification`; the key condition must match one partition key value, and any filter used with it must reference non-key attributes.

aws dynamodb export-table-to-point-in-time --table-arn <table-arn> --s3-bucket <bucket> --filter-specification '{"KeyConditionExpression":"#pk = :pk","FilterExpression":"#status = :status","ProjectionExpression":"#pk, #status, #attribute","ExpressionAttributeNames":{"#pk":"<partition-key-name>","#status":"<status-attribute>","#attribute":"<projected-attribute>"},"ExpressionAttributeValues":{":pk":{"S":"<partition-key-value>"},":status":{"S":"<status-value>"}}}'

WHY THIS HELPS

Export point-in-time table data with selected records or attributes.

REQUIREMENTS AND LIMITATIONS

  • Version: 2.37.7
  • --filter-specification: Object containing export filter criteria. Its expression subkeys can be combined in one request.
  • FilterExpression: Filters exported items; when KeyConditionExpression is omitted, may reference key attributes too.
  • ProjectionExpression: Names the attributes included in output; separate names with commas.
  • KeyConditionExpression: Filters by key; requires equality on one partition key and may compare a sort key. When supplied, FilterExpression can reference only non-key attributes.
  • ExpressionAttributeNames: Map of substitution tokens to attribute names used by expressions.
  • ExpressionAttributeValues: Map of substitution tokens to DynamoDB attribute values used by expressions.
  • --table-arn (required): ARN of the table to export.
  • --s3-bucket (required): Destination S3 bucket name.
  • Prerequisite: Enable point-in-time recovery (PITR) on the table; export time must be within its configured PITR recovery period.
  • Prerequisite: IAM permissions must allow `dynamodb:ExportTableToPointInTime`, `s3:AbortMultipartUpload`, `s3:PutObject`, and `s3:PutObjectAcl`. The caller must be in the same AWS account as the source table.
  • Docs conflict: The accessible AWS CLI reference is for version 2.37.10, newer than the card’s 2.37.7. Its current export command documents these expressions under --filter-specification; version 2.37.7 documentation could not be opened to verify the exact syntax for that version.

FIRST-PARTY EVIDENCE

Check the installed version and the source before using it. Entry JSON

Report a problem with this card