Adapter Online Help > TDV Amazon DynamoDB Adapter > Data Model > Stored Procedures
 
Stored Procedures
Stored procedures are available to complement the data available from the NoSQL Database. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
Amazon DynamoDB Adapter Stored Procedures
Name
Description
CreateSchema
Creates a schema file for the specified table or view.
CreateTable
Creates a table in DynamoDB.
CreateSchema
Creates a schema file for the specified table or view.
Input
Name
Type
Description
TableName
String
The name of the table or view.
FileName
String
The full file path and name of the schema to generate. Ex : 'C:\\Users\\User\\Desktop\\SmartSheet\\sheet.rsd'
Output
Name
Type
Description
Result
String
Returns Success or Failure.
CreateTable
Creates a table in DynamoDB.
Input
Name
Type
Description
Tablename
String
The name of the table to create. A minimum of 3 characters and maximum of 255 characters are allowed.
Keyschema_attributename#
String
The attribute name of a primary key for the schema. At least one is required. A maximum of 2 can be specified.
Keyschema_keytype#
String
The type of key for a primary key for the schema. At least one is required. A maximum of 2 can be specified.
The allowed values are HASH, RANGE.
Provisionedthroughput_readcapacityunits
String
A long representing the maximum number of strongly consistent reads consumed per second before DynamoDB returns a ThrottlingException.
Provisionedthroughput_writecapacityunits
String
A long representing the maximum number of strongly consistent writes consumed per second before DynamoDB returns a ThrottlingException.
Attributedefinitions_attributename#
String
The name of an attribute or column to add to the table. Minimum length of 1, Maximum length of 255.
Attributedefinitions_attributetype#
String
The type of attribute or column to add to the table. Enter S, N, or B for string, number or boolean.
The allowed values are S, N, B.
Globalsecondaryindexes_indexname#
String
One or more global secondary indexes. The maximum is five and the minimum 1. The name of the global secondary index, which must be unique only within this table. Minimum length of 3; maximum 255 characters.
Globalsecondaryindexes_keyschema#
String
The full KeySchema JSON structure, which consists of an array of attribute names and key types. There must be at least one entry and a maximum of two can be specified.
Globalsecondaryindexes_projection#
String
The full Projection JSON structure, which represents attributes that are copied (projected) from the table into an index. These are in addition to the primary key attributes and index key attributes, which are automatically projected. A minimum of one projection object and a maximum of 20 are in the list.
Globalsecondaryindexes_provisionedthroughput_readcapacityunits#
String
A long representing the maximum number of strongly consistent reads consumed per second before DynamoDB returns a ThrottlingException.
Globalsecondaryindexes_provisionedthroughput_writecapacityunits#
String
A long representing the maximum number of strongly consistent writes consumed per second before DynamoDB returns a ThrottlingException.
Localsecondaryindexes_indexname#
String
One or more global secondary indexes. The maximum is five. The minimum is 1. The name of the global secondary index must be unique only within this table. Minimum length of 3; maximum 255 characters.
Localsecondaryindexes_keyschema#
String
The full KeySchema JSON structure, which consists of an array of attribute names and key types. There must be at least one entry and a maximum of two can be specified.
Localsecondaryindexes_projection#
String
The full Projection JSON structure, which represents attributes that are copied (projected) from the table into an index. These are in addition to the primary key attributes and index key attributes, which are automatically projected. A minimum of one projection object and a maximum of 20 are in the list.
Output
Name
Type
Description
Attributedefinitions_attributename#
String
The name of an attribute on the table. This will be either a primary key, a global secondary index, or a local secondary index.
Attributedefinitions_attributetype#
String
The type of an attribute on the table. This will be either a primary key, a global secondary index, or a local secondary index.
Createdondatetime
String
The date and time when the table was created in UNIX epoch time.
Globalsecondaryindexes_indexname#
String
The name of the global secondary index.
Globalsecondaryindexes_indexsizebytes#
String
The total size of the global secondary index, in bytes. DynamoDB updates this value approximately every six hours. Recent changes might not be reflected in this value.
Globalsecondaryindexes_indexstatus#
String
The current status of the global secondary index. Valid values are CREATING, UPDATING, DELETING, and ACTIVE.
Globalsecondaryindexes_itemcount#
String
The number of items in the global secondary index. DynamoDB updates this value approximately every six hours. Recent changes might not be reflected in this value.
Globalsecondaryindexes_provisionedthroughput_lastdecreasedatetime#
String
The date and time of the last provisioned throughput decrease for this index.
Globalsecondaryindexes_provisionedthroughput_lastincreasedatetime#
String
The date and time of the last provisioned throughput increase for this index.
Globalsecondaryindexes_provisionedthroughput_numberofdecreasestoday#
String
The number of provisioned throughput decreases for this index during this UTC calendar day. For current maximums on provisioned throughput decreases, see Limits in the Amazon DynamoDB Developer Guide.
Globalsecondaryindexes_provisionedthroughput_readcapacityunits#
String
The maximum number of strongly consistent reads consumed per second before DynamoDB returns a ThrottlingException. Eventually consistent reads require less effort than strongly consistent reads, so a setting of 50 ReadCapacityUnits per second provides 100 eventually consistent ReadCapacityUnits per second.
Globalsecondaryindexes_provisionedthroughput_writecapacityunits#
String
The maximum number of writes consumed per second before DynamoDB returns a ThrottlingException.
Keyschema_attributename#
String
The name of a key attribute.
Keyschema_keytype#
String
The type of key for a primary key for the schema.
Localsecondaryindexes_indexname#
String
The name of the local secondary index. The name must be unique among all other indexes on this table.
Provisionedthroughput_readcapacityunits
String
A long representing the maximum number of strongly consistent reads consumed per second before DynamoDB returns a ThrottlingException.
Provisionedthroughput_writecapacityunits
String
A long representing the maximum number of strongly consistent writes consumed per second before DynamoDB returns a ThrottlingException.