Page Comparison

On this Page

Table of Contents

maxLevel	2
exclude	Older Versions\|Additional Resources\|Related Links\|Related Information

Snap type:

Write

Description:

This Snap provides the ability to read data from a DynamoDB table. The table becomes suggestible once the account is defined.

Expected upstream Snaps: Any Snap that provides a document output view, such as Structure or a JSON Generator Snap.
Expected downstream Snaps: Any Snap that has a document input view, such as Filter or Data or JSON Formatter.
Expected input: The table schema is suggested on input view. The attribute values for the attributes of the table for each record are passed from input view.
Expected output: This Snap provides the result of the Bulk Write operation for each request. Errors can be routed to the error view if enabled or cause the Snap to fail during execution.

Prerequisites:

None

Support and limitations:

Ultra pipelines: Works Works in Ultra Pipelines.Spark mode: Not supported in /wiki/spaces/SD/pages/1437917 modeTask Pipelines.

Account:

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint.

See DynamoDB Account for information on setting up this type of account.

Views:

Input	This Snap has exactly one document input view.
Output	This Snap has exactly one document output view.
Error	This Snap has at most one document error view and produces zero or more documents in the view.

Settings

Label

Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Table name

Required. The name of the table to write the data into. This property is suggestible, which shows the list of the tables in db.
Example: Thread
Default value: [None]

Thread count

This property represents the total number of parallel threads to be created for Bulk Get operation.
Example: 2
Default value: None

Projection expression

String that identifies one or more attributes to retrieve from the specified table. If more than one attribute is to be retrieved then those should be separated by commas.
Example: LastPostDateTime, ForumName, Subject
Default value: None

Batch Size

Number of records batched for each request.
Example: 25
Default value: None

Expression attribute values

Specify the placeholders for the Expression Attribute Names and/or Expression Attribute Values.

Info

DynamoDB reserves certain words and they are called reserved words. You must not use reserved words as attribute names in expressions. If you must write an expression that contains a word that conflicts with a DynamoDB reserved word, then you can define an expression attribute name to use in the place of the reserved word. For more information, see Expression Attribute Names.

Similarly, you cannot use certain values as attribute values in expressions and instead must define an expression attribute name. For more information, see Expression Attribute Values.

Click + to enter:

Attribute: The expression attribute name. Begins with a # for names and : for values.
Type: The attribute type. Blank for Expression Attribute Names. S for string, N for number, and so on, for Values.
Value: The actual literal to be used in the bulk get condition.

Example

If your table contains a column named uuid (a reserved word) and you want to read a value from the uuid column, then you must assign a placeholder for the column name because you cannot use a reserved word directly in your expression. We can define the Attribute #U, leave the Type blank, and enter the value as uuid. In the Snap Projection expression condition, we enter #U.

Attribute	Type	Value
#U		uuid

Multiexcerpt include macro

name	Snap Execution
page	SOAP Execute

Multiexcerpt include macro

name	Execution_Detail_Write
page	SOAP Execute

Example

In this pipeline, the DynamoDB Bulk Get Snap reads the records from a specific table. The Mapper is reconfigured to match the target schema and provided with a value from the DynamoDB table for the Bulk Get Snap to output data correctly.

Image Modified

The Mapper Snap maps the value for the table student to retrieve the records that matches the condition:

(Ensure to map the target schema to the specified expression for a successful output preview)Image Modified

The DynamoDB Bulk Get Snap reads the records from the table, student with the mapped expression from the upstream Snap:

The successful execution of the pipeline displays the below output preview:

Image Modified

Insert excerpt

	DynamoDB Snap Pack
	DynamoDB Snap Pack
nopanel	true

Versions Compared

Old Version 17

New Version Current

Key

Settings

Example