Official |[Amazon DynamoDB] Delete Item

Operation name

Delete Item

Function overview

Deletes items in an Amazon DynamoDB table where the primary key matches with the primary key received from input data.

= Remarks =

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

"DeleteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_DeleteItem.html)
"BatchWriteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_BatchWriteItem.html)

Data model

The data model of this component is table model type.

Properties

= Remarks =

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 a name that is used 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 connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Table name	Required	Available	Select or enter a table name where items will be deleted.
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's a hash key attribute of the table specified in Table name or not.
Primary key list/Range key	Optional	Not available	Displays whether it's 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's 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. For 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 gotten 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 for the data type 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. Selected Batch writing will be performed. Not selected (Default) Batch writing won't be performed.	When Enable batch writing is selected, requests to delete up to 25 items at a time will be sent.

Item name

Required/Optional

Use of variables

Description

Remarks

Enable batch writing

Optional

Not available

Select whether or not to enable batch writing.

Selected

Batch writing will be performed.

Not selected

(Default)

Batch writing won't be performed.

When Enable batch writing is selected, requests to delete up to 25 items at a time will be sent.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

The number of columns varies depending on the Primary key list settings.

= Remarks =

For schema structure, refer to Table model type .

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP is supported.

= Remarks =

For details on PSP, 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.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the Amazon DynamoDB connector

Notes

When a request to Amazon DynamoDB fails due to a reason such as a connection timeout, the request will be retried 10 times.