The create_table operation adds a new table
to your account. In an AWS account, table names must be unique within
each Region. That is, you can have two tables with same name if you
create the tables in different Regions.
create_table is an asynchronous operation.
Upon receiving a create_table request,
DynamoDB immediately returns a response with a TableStatus of
CREATING. After the table is created, DynamoDB sets the TableStatus
to ACTIVE. You can perform read and write operations only on an
ACTIVE table.
You can optionally define secondary indexes on the new table, as part of
the create_table operation. If you want to
create multiple tables with secondary indexes on them, you must create
the tables sequentially. Only one table with secondary indexes can be in
the CREATING state at any given time.
You can use the describe_table action to
check the table status.
dynamodb_create_table(AttributeDefinitions, TableName, KeySchema,
LocalSecondaryIndexes, GlobalSecondaryIndexes, BillingMode,
ProvisionedThroughput, StreamSpecification, SSESpecification, Tags)A list with the following syntax:
list(
TableDescription = list(
AttributeDefinitions = list(
list(
AttributeName = "string",
AttributeType = "S"|"N"|"B"
)
),
TableName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
TableStatus = "CREATING"|"UPDATING"|"DELETING"|"ACTIVE"|"INACCESSIBLE_ENCRYPTION_CREDENTIALS"|"ARCHIVING"|"ARCHIVED",
CreationDateTime = as.POSIXct(
"2015-01-01"
),
ProvisionedThroughput = list(
LastIncreaseDateTime = as.POSIXct(
"2015-01-01"
),
LastDecreaseDateTime = as.POSIXct(
"2015-01-01"
),
NumberOfDecreasesToday = 123,
ReadCapacityUnits = 123,
WriteCapacityUnits = 123
),
TableSizeBytes = 123,
ItemCount = 123,
TableArn = "string",
TableId = "string",
BillingModeSummary = list(
BillingMode = "PROVISIONED"|"PAY_PER_REQUEST",
LastUpdateToPayPerRequestDateTime = as.POSIXct(
"2015-01-01"
)
),
LocalSecondaryIndexes = list(
list(
IndexName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
Projection = list(
ProjectionType = "ALL"|"KEYS_ONLY"|"INCLUDE",
NonKeyAttributes = list(
"string"
)
),
IndexSizeBytes = 123,
ItemCount = 123,
IndexArn = "string"
)
),
GlobalSecondaryIndexes = list(
list(
IndexName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
Projection = list(
ProjectionType = "ALL"|"KEYS_ONLY"|"INCLUDE",
NonKeyAttributes = list(
"string"
)
),
IndexStatus = "CREATING"|"UPDATING"|"DELETING"|"ACTIVE",
Backfilling = TRUE|FALSE,
ProvisionedThroughput = list(
LastIncreaseDateTime = as.POSIXct(
"2015-01-01"
),
LastDecreaseDateTime = as.POSIXct(
"2015-01-01"
),
NumberOfDecreasesToday = 123,
ReadCapacityUnits = 123,
WriteCapacityUnits = 123
),
IndexSizeBytes = 123,
ItemCount = 123,
IndexArn = "string"
)
),
StreamSpecification = list(
StreamEnabled = TRUE|FALSE,
StreamViewType = "NEW_IMAGE"|"OLD_IMAGE"|"NEW_AND_OLD_IMAGES"|"KEYS_ONLY"
),
LatestStreamLabel = "string",
LatestStreamArn = "string",
GlobalTableVersion = "string",
Replicas = list(
list(
RegionName = "string",
ReplicaStatus = "CREATING"|"CREATION_FAILED"|"UPDATING"|"DELETING"|"ACTIVE"|"REGION_DISABLED"|"INACCESSIBLE_ENCRYPTION_CREDENTIALS",
ReplicaStatusDescription = "string",
ReplicaStatusPercentProgress = "string",
KMSMasterKeyId = "string",
ProvisionedThroughputOverride = list(
ReadCapacityUnits = 123
),
GlobalSecondaryIndexes = list(
list(
IndexName = "string",
ProvisionedThroughputOverride = list(
ReadCapacityUnits = 123
)
)
),
ReplicaInaccessibleDateTime = as.POSIXct(
"2015-01-01"
)
)
),
RestoreSummary = list(
SourceBackupArn = "string",
SourceTableArn = "string",
RestoreDateTime = as.POSIXct(
"2015-01-01"
),
RestoreInProgress = TRUE|FALSE
),
SSEDescription = list(
Status = "ENABLING"|"ENABLED"|"DISABLING"|"DISABLED"|"UPDATING",
SSEType = "AES256"|"KMS",
KMSMasterKeyArn = "string",
InaccessibleEncryptionDateTime = as.POSIXct(
"2015-01-01"
)
),
ArchivalSummary = list(
ArchivalDateTime = as.POSIXct(
"2015-01-01"
),
ArchivalReason = "string",
ArchivalBackupArn = "string"
)
)
)
[required] An array of attributes that describe the key schema for the table and indexes.
[required] The name of the table to create.
[required] Specifies the attributes that make up the primary key for a table or an
index. The attributes in KeySchema must also be defined in the
AttributeDefinitions array. For more information, see Data Model
in the Amazon DynamoDB Developer Guide.
Each KeySchemaElement in the array is composed of:
AttributeName - The name of this key attribute.
KeyType - The role that the key attribute will assume:
HASH - partition key
RANGE - sort key
The partition key of an item is also known as its hash attribute. The term "hash attribute" derives from the DynamoDB usage of an internal hash function to evenly distribute data items across partitions, based on their partition key values.
The sort key of an item is also known as its range attribute. The term "range attribute" derives from the way DynamoDB stores items with the same partition key physically close together, in sorted order by the sort key value.
For a simple primary key (partition key), you must provide exactly one
element with a KeyType of HASH.
For a composite primary key (partition key and sort key), you must
provide exactly two elements, in this order: The first element must have
a KeyType of HASH, and the second element must have a KeyType of
RANGE.
For more information, see Working with Tables in the Amazon DynamoDB Developer Guide.
One or more local secondary indexes (the maximum is 5) to be created on the table. Each index is scoped to a given partition key value. There is a 10 GB size limit per partition key value; otherwise, the size of a local secondary index is unconstrained.
Each local secondary index in the array includes the following:
IndexName - The name of the local secondary index. Must be unique
only for this table.
KeySchema - Specifies the key schema for the local secondary
index. The key schema must begin with the same partition key as the
table.
Projection - Specifies attributes that are copied (projected) from
the table into the index. These are in addition to the primary key
attributes and index key attributes, which are automatically
projected. Each attribute specification is composed of:
ProjectionType - One of the following:
KEYS_ONLY - Only the index and primary keys are projected
into the index.
INCLUDE - Only the specified table attributes are
projected into the index. The list of projected attributes
is in NonKeyAttributes.
ALL - All of the table attributes are projected into the
index.
NonKeyAttributes - A list of one or more non-key attribute
names that are projected into the secondary index. The total
count of attributes provided in NonKeyAttributes, summed
across all of the secondary indexes, must not exceed 100. If you
project the same attribute into two different indexes, this
counts as two distinct attributes when determining the total.
One or more global secondary indexes (the maximum is 20) to be created on the table. Each global secondary index in the array includes the following:
IndexName - The name of the global secondary index. Must be unique
only for this table.
KeySchema - Specifies the key schema for the global secondary
index.
Projection - Specifies attributes that are copied (projected) from
the table into the index. These are in addition to the primary key
attributes and index key attributes, which are automatically
projected. Each attribute specification is composed of:
ProjectionType - One of the following:
KEYS_ONLY - Only the index and primary keys are projected
into the index.
INCLUDE - Only the specified table attributes are
projected into the index. The list of projected attributes
is in NonKeyAttributes.
ALL - All of the table attributes are projected into the
index.
NonKeyAttributes - A list of one or more non-key attribute
names that are projected into the secondary index. The total
count of attributes provided in NonKeyAttributes, summed
across all of the secondary indexes, must not exceed 100. If you
project the same attribute into two different indexes, this
counts as two distinct attributes when determining the total.
ProvisionedThroughput - The provisioned throughput settings for
the global secondary index, consisting of read and write capacity
units.
Controls how you are charged for read and write throughput and how you manage capacity. This setting can be changed later.
PROVISIONED - We recommend using PROVISIONED for predictable
workloads. PROVISIONED sets the billing mode to Provisioned Mode.
PAY_PER_REQUEST - We recommend using PAY_PER_REQUEST for
unpredictable workloads. PAY_PER_REQUEST sets the billing mode to
On-Demand Mode.
Represents the provisioned throughput settings for a specified table or
index. The settings can be modified using the
update_table operation.
If you set BillingMode as PROVISIONED, you must specify this property.
If you set BillingMode as PAY_PER_REQUEST, you cannot specify this
property.
For current minimum and maximum provisioned throughput values, see Service, Account, and Table Quotas in the Amazon DynamoDB Developer Guide.
The settings for DynamoDB Streams on the table. These settings consist of:
StreamEnabled - Indicates whether DynamoDB Streams is to be
enabled (true) or disabled (false).
StreamViewType - When an item in the table is modified,
StreamViewType determines what information is written to the
table's stream. Valid values for StreamViewType are:
KEYS_ONLY - Only the key attributes of the modified item are
written to the stream.
NEW_IMAGE - The entire item, as it appears after it was
modified, is written to the stream.
OLD_IMAGE - The entire item, as it appeared before it was
modified, is written to the stream.
NEW_AND_OLD_IMAGES - Both the new and the old item images of
the item are written to the stream.
Represents the settings used to enable server-side encryption.
A list of key-value pairs to label the table. For more information, see Tagging for DynamoDB.
svc$create_table(
AttributeDefinitions = list(
list(
AttributeName = "string",
AttributeType = "S"|"N"|"B"
)
),
TableName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
LocalSecondaryIndexes = list(
list(
IndexName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
Projection = list(
ProjectionType = "ALL"|"KEYS_ONLY"|"INCLUDE",
NonKeyAttributes = list(
"string"
)
)
)
),
GlobalSecondaryIndexes = list(
list(
IndexName = "string",
KeySchema = list(
list(
AttributeName = "string",
KeyType = "HASH"|"RANGE"
)
),
Projection = list(
ProjectionType = "ALL"|"KEYS_ONLY"|"INCLUDE",
NonKeyAttributes = list(
"string"
)
),
ProvisionedThroughput = list(
ReadCapacityUnits = 123,
WriteCapacityUnits = 123
)
)
),
BillingMode = "PROVISIONED"|"PAY_PER_REQUEST",
ProvisionedThroughput = list(
ReadCapacityUnits = 123,
WriteCapacityUnits = 123
),
StreamSpecification = list(
StreamEnabled = TRUE|FALSE,
StreamViewType = "NEW_IMAGE"|"OLD_IMAGE"|"NEW_AND_OLD_IMAGES"|"KEYS_ONLY"
),
SSESpecification = list(
Enabled = TRUE|FALSE,
SSEType = "AES256"|"KMS",
KMSMasterKeyId = "string"
),
Tags = list(
list(
Key = "string",
Value = "string"
)
)
)
if (FALSE) {
# This example creates a table named Music.
svc$create_table(
AttributeDefinitions = list(
list(
AttributeName = "Artist",
AttributeType = "S"
),
list(
AttributeName = "SongTitle",
AttributeType = "S"
)
),
KeySchema = list(
list(
AttributeName = "Artist",
KeyType = "HASH"
),
list(
AttributeName = "SongTitle",
KeyType = "RANGE"
)
),
ProvisionedThroughput = list(
ReadCapacityUnits = 5L,
WriteCapacityUnits = 5L
),
TableName = "Music"
)
}
Run the code above in your browser using DataLab