DynamoDB Writer Feature Type Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, which may include the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
These parameters apply only to a selected feature type, not to the entire writer.
Tip: 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 Parameters
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.