All Collections
Actions
Amazon Web Services
Delete DynamoDB Items Actions
Delete DynamoDB Items Actions
Matt Houser avatar
Written by Matt Houser
Updated over a week ago

Description

The Delete DynamoDB Items action can be used to scan a DynamoDB table and delete many items based on the date stored in an item's attribute.

Test Mode

The Delete DynamoDB Items action includes a "test mode" as a way of determining which items will be deleted without actually deleting the items. This way, you can fine tune your action without concern for deleting the wrong items. Test Mode is on by default.

When test mode is enabled, execute your action normally then check the action logs to verify that only items that should have been deleted would have been deleted, and that items that should not have been deleted would not have been deleted.

When you are satisfied, disable Test Mode.

Settings

Please see Common Action Settings for a description of settings common to all action types.

Table Name

The name of the DynamoDB table in which to delete items.

Date Attribute

The name of the attribute which stores the items date for comparison.

Older Than (days)

Only items with a date attribute older than the specified number of days will be deleted.

Date Type

The date type stored in the date attribute. Possible types are:

  • OLE Automation (OA) - Numeric representation of dates used by OLE Automation. The data type is a number.

  • ISO 8601 - String representation of dates. The data type is a string.

  • Unix Time - Numeric representation of dates used by unix systems. The data type is a number.

  • .Net Ticks - Numeric representation of dates retrieved from the Ticks member of a .Net System.DateTime object. The data type is a number.

Scan Limit

Indicates the maximum number of items to scan each scan attempt. Adjust this value according to your average item size and provisioned throughput. Using large values will decrease the amount of time to find items to delete, but increases the chance of exceeding your provisioned throughput.

Test Mode

Enables and disabled Test Mode (see above).

Amazon Commands Used

The following Amazon AWS commands are used. The access key should have permission to execute all of them.

  • dynamodb:DescribeTable

  • dynamodb:Scan

  • dynamodb:DeleteItem

Did this answer your question?