Delete Item

Operation Name

Delete Item

Function Overview

Delete items matching with the primary key received in input data among the items in an Amazon DynamoDB table.

This operation uses DeleteItem API or BatchWriteItem API. For more details on API specifications, refer to the following pages.

Data Model

Table model type.

Properties

For details on use of variables, refer to “Variables”.
Basic settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not available Enter the name to show on the script canvas.  
Input data Required Not available Select a component on the script canvas.  
Required settings
Item name Required/Optional Use of variables Description Remarks
Destination Required Not available Select a global resource.
  • [Add]:
    Add a new global resource.
  • [Edit list]:
    Global resource settings can be edited in “Edit resource list” screen.
  
Table name Required Available Select or enter a table name where to delete items.  
Primary key list Required - Specify primary key list of the table specified in [Table name].  
Primary key list/Hash key Optional Not available Displays whether it is a hash key attribute of the table specified in [Table name] or not.  
Primary key list/Range key Optional Not available Displays whether it is a range key attribute of the table specified in [Table name] or not.  
Primary key list/Attribute name Required Available Displays an attribute name of the table specified in [Table name].
  • The specified attribute name is displayed in Mapper schema.
Primary key list/Type Required Not available Select the type of [Attribute name].
  • It is displayed in “<DynamoDB data type> (<Internal data type>)” format.
    • DynamoDB data type:
      Data type supported by Amazon DynamoDB.
    • Internal data type:
      Data type used internally within DataSpider.
      For more details, refer to “Internal Data Types”.
Property actions
Item name Description Remarks
Update table name list Get table names in the specified destination and set them in [Table name].  
Update primary key list Update primary key list of the table specified in [Table name].
  • Enabled when [Table name] is specified.
  • Data types of primary keys are extracted from the items got by executing a scan for the table specified in [Table name].
  • When there are no items in the table specified in [Table name], [String (String)] is set irrespective of the actual primary key type.
Write settings
Item name Required/Optional Use of variables Description Remarks
Enable batch writing Optional Not available Select whether or not to enable batch writing.
  • [Checked]:
    Batch writing will be performed.
  • [Not checked]: (default)
    Batch writing will not be performed.
  • When [Checked] is selected in [Enable batch writing], deletion requests will be sent by 25 items at the maximum at a time.
Comment
Item name Required/Optional Use of variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input schema

The number of columns differs depending on the [Primary key list] settings.
For more details, refer to “Schema of table model type”.

Output schema

None.

Loading schema in Mapper

Schema is loaded automatically.
For more details, refer to “Edit Schema”.

Transaction

Transaction is not supported.

PSP Usage

PSP is supported.
For more details, refer to “Parallel Stream Processing”.

Available Component Variables

Component variable name Description Remarks
count The number of delete requests that has been sent is stored.
  • Default value is null.
message_category When an error occurs, the corresponding message code's category is stored.
  • Default value is null.
message_code When an error occurs, the corresponding message code is stored.
  • Default value is null.
message_level When an error occurs, the corresponding message code's severity is stored.
  • Default value is null.
error_type When an error occurs, the error type is stored.
  • Default value is null.
  • The error type will be in the following format.
    Example: “java.io.FileNotFoundException”
  • The contents that will be stored may vary depending on DataSpider Servista versions.
error_message When an error occurs, the error message is stored.
  • Default value is null.
  • The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace When an error occurs, the error's trace information is stored.
  • Default value is null.
  • The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Specification Limits

For details on specification limits common to the operations, refer to “Amazon DynamoDB Adapter Limitations”.

Major Exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition is not found. Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition is not found. Name: [<global resource name>]		 The resource definition specified in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
<property name> is not specified.		 [<property name>] is not specified. Specify [<property name>].

Notes