ODBC Driver for Amazon DynamoDB

Build 25.0.9434

CreateTable

Creates a new table in DynamoDB with specified partition and sort keys, along with optional billing mode and capacity settings.

Input

Name Type Required Description
TableName String True The name of the table to create, which must be between 3 and 255 characters. This is a required parameter for table creation.
PartitionKeyName String True Specifies the name of the partition key, which is mandatory for uniquely identifying items in the table.
PartitionKeyType String True Defines the data type of the partition key, such as 'String', 'Number', or 'Binary'. This determines how the partition key will be stored and indexed.

The allowed values are S, N, B.

SortKeyName String False Specifies the name of the sort key, which is optional and used for secondary organization of data within a partition.
SortKeyType String False Defines the data type of the sort key, such as 'String', 'Number', or 'Binary', if a sort key is provided.

The allowed values are S, N, B.

BillingMode String False Specifies how you are billed for throughput capacity. Options include 'PROVISIONED' for manual capacity management or 'PAY_PER_REQUEST' for on-demand scaling.

The allowed values are PROVISIONED, PAY_PER_REQUEST.

The default value is PROVISIONED.

ReadCapacityUnits String False Defines the maximum number of strongly consistent read operations per second, applicable only when 'BillingMode' is set to 'PROVISIONED'.

The default value is 5.

WriteCapacityUnits String False Defines the maximum number of write operations per second, applicable only when 'BillingMode' is set to 'PROVISIONED'.

The default value is 5.

Result Set Columns

Name Type Description
Success String Indicates the outcome of the operation. Returns 'True' if the table was created successfully, otherwise 'False'.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434