Create/Replace Item

Operation Name

Create/Replace Item

Function Overview

Writes input data to Amazon DynamoDB table.

In this operation, PutItem API or BatchWriteItem API is available. Refer to the following page about API specification.

Data Model

Table model type.

Properties

For the use of variables, refer to "Variable".
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 the 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]:
    Adds a new global resource.
  • [Edit list]:
    Enables to edit the global resource setting on " Resource edit list" screen.
  
Table name Required Available Select or enter the name of writing table name.  
Attribute list Required - Specifies index attribute list specified in table of [Table name].
Added row becomes write targeted column.

Each write targeted column can be operated with the following button.
  • [Add]:
    Adds a write targeted column.
  • [Up]:
    Moves the order of the selected write targeted column upwards by one.
  • [Down]:
    Moves the order of the selected write targeted column downwards by one.
  • [Delete]:
    Deletes a write targeted column.
  
Attribute list/Hash key Optional Not available Shows whether or not the hash key attribute of the table specified in [Table name].  
Attribute list/Range key Optional Not available Shows whether or not the range key attribute of the table specified in [Table name].  
Attribute list/Attribute name Required Available Enters attribute name of table specified in [Table name].
  • Specified attribute name is showed to Mapper schema.
Attribute list/Type Required Not available Select [Attribute name] type.
  • Showed in "<DynamoDB data type> (<Inner data type>)" format.
    • DynamoDB data type:
      Data type supported by Amazon DynamoDB.
    • Inner data type:
      Data type used in inner DataSpider.
      For details, refer to "Inner data type".
Property action
Item name Description Remarks
Update table name list Gets table name in the specified destination and set to [Table name].  
Update attribute list Perform query to the table specified in [Table name] and set the attribute list that exists in the first 10 cases in the received items into the attribute list.
  • Enabled, if [Table name] is specified.
  • Extracts attribute name and data type from item received implementing Scan, to table specified in [Table name]
  • If unsupported DynamoDB data type attribute exists in the received item by Scan, the attribute is not added to attribute list.
    • For supported type, refer to "Amazon DynamoDB Adapter Restriction".
  • If item does not exist to table specified in [Table name], sets primary key only.
    Also, data type sets [String (String)] regardless of the actual attribute type.
Write settings
Item name Required/Optional Use of variables Description Remarks
Enable batch writing Optional Not available Select whether to enable batch writing or not.
  • [Checked]:
    Performs batch writing.
  • [Not checked]:(default)
    Does not perform batch writing.
  • If [Checked] is selected in [Enable batch writing], sends add/update item request by maximum 25 cases.
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

Column number differs depending on the setting of [Attribute list].
For details on schema structure, refer to "Table model type schema".

Output Schema

None.

Loading Schema on Mapper

Schema is loaded automatically.
For details, refer to "Edit Schema".

Transaction

Transaction is not supported.

PSP Usage

PSP is supported.
For details on PSP, refer to "Parallel Stream Processing".

Available Component Variables

Component variable name Description Remarks
count Stores the number of sent create/replace request.
  • Default value is null.
message_category Stores the category of message code corresponding to the occurred error.
  • Default value is null.
message_code Stores the code of message code corresponding to the occurred error.
  • Default value is null.
message_level Stores the severity of message code corresponding to the occurred error.
  • Default value is null.
error_type Stores the error type of occurred error.
  • Default value is null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The value may vary depending on the DataSpider Servista version.
error_message Stores the error message of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version.
error_trace Stores the trace information of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version or the client application used.

Specification Limits

For specification limits common to each operations, refer to "Amazon DynamoDB Adapter Restriction".

Main Exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found. Name:[]		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found. Name:[<Global resource name>]		 Resource definition specified in [Destination] is not found. Check global resource specified in [Destination].
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify [<Property name>].

Notes