DynamoDB Writer Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Window Layout > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Important  These parameters apply only to a selected feature type, not to the entire writer. If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.

Table Settings: General

The default operation mode of the feature type in terms of the types of statements sent to the database.

Note  The primary key is the partition key, or the partition key and the sort key (if it exists).
  • Put (default) creates new items in the destination table. If an item with the same primary key already exists, the existing item is overwritten by the new item.
  • Insert creates new items in the destination table. If an item with the same primary key already exists, the new item is not added to the table.
  • Update modifies an existing item in the destination table. If the attributes to be updated exist on the item with the specified primary key, the attributes are set to the new value. Otherwise, the attributes and their values are added to the item.
  • Delete deletes existing items in the destination table that have their primary key specified.

If this parameter is set to Yes, and the table exists by this name, it should be dropped and recreated before any features are written to it.

Table Creation

Read Capacity Units

Create the table using the read capacity specified. Default: 5

To avoid accidental expenditures, the DynamoDB writer does not support creating tables with a read capacity of more than 100. Please use the native AWS user interface if a greater read capacity is needed.

Write Capacity Units

Create the table using the write capacity specified. Default: 5

To avoid accidental expenditures, the DynamoDB writer does not support creating tables with a write capacity of more than 100. Please use the native AWS user interface if a greater write capacity is needed.

Specifies that a secondary index is to be created when a table is created. When left unchecked (which is the default), the other configuration parameters are disabled.

Index Type

The type of the secondary index to create. Local secondary indexes must have the same partition key as the table, while global secondary indexes may have a different partition key and/or sort key. Global secondary indexes have their own provisioned capacities, and are billed separately from the table.

Default: GSI

Partition Key

The partition key of the secondary index to create.

Sort Key

The sort key of the secondary index to create.

Index Name

The name of the secondary index to create. If no name is given, the DynamoDB writer will generate a default name based on the index’s primary key.

Projected Attributes

This specifies which attributes of the table are projected on the secondary index to create.

Valid values: ALL (default), KEYS_ONLY, and INCLUDE.

Include

The non-key attributes that are projected on the secondary index to create if the Projected Attributes parameter is set to INCLUDE.

Read Capacity Units

Create the global secondary index with the read capacity specified.

To avoid accidental expenditures, the DynamoDB writer does not support creating indexes with a read capacity of more than 100. Please use the native AWS user interface if a greater read capacity is needed.

Default: 5

Write Capacity Units

Create the global secondary index with the write capacity specified.

To avoid accidental expenditures, the DynamoDB writer does not support creating indexes with a write capacity of more than 100. Please use the native AWS user interface if a greater read capacity is needed.

Default: 5

Advanced

The source of items to write to the table.

Feature

Items will be created from attributes on features sent to the DynamoDB Writer (which is the usual behavior).

JSON Attribute

Items will be created using JSON directly from an attribute, if possible.

This parameter is enabled when Document Source is JSON Attribute. It can be used to specify an attribute to use directly as the document JSON. Any features that contain the JSON attribute are written using the JSON attribute value. Other features are written normally.