create_table
¶
create_table(
table_name: TableArn,
*,
config_overrides: Optional[DynamoDBClientConfig] = None,
attribute_definitions: Optional[AttributeDefinitions] = None,
key_schema: Optional[KeySchema] = None,
local_secondary_indexes: Optional[LocalSecondaryIndexList] = None,
global_secondary_indexes: Optional[GlobalSecondaryIndexList] = None,
billing_mode: Optional[BillingMode] = None,
provisioned_throughput: Optional[ProvisionedThroughput] = None,
stream_specification: Optional[StreamSpecification] = None,
sse_specification: Optional[SSESpecification] = None,
tags: Optional[TagList] = None,
table_class: Optional[TableClass] = None,
deletion_protection_enabled: Optional[DeletionProtectionEnabled] = None,
warm_throughput: Optional[WarmThroughput] = None,
resource_policy: Optional[ResourcePolicy] = None,
on_demand_throughput: Optional[OnDemandThroughput] = None,
global_table_source_arn: Optional[TableArn] = None,
global_table_settings_replication_mode: Optional[
GlobalTableSettingsReplicationMode
] = None,
vector_indexes: Optional[VectorIndexList] = None,
) -> CreateTableOutput
The CreateTable operation adds a new table to your account. In an Amazon Web Services 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.
CreateTable is an asynchronous operation. Upon receiving a CreateTable 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 CreateTable 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 DescribeTable action to check the table status.
Parameters:
-
attribute_definitions(Optional[AttributeDefinitions], default:None) –An array of attributes that describe the key schema for the table and indexes.
-
table_name(TableArn) –The name of the table to create. You can also provide the Amazon Resource Name (ARN) of the table in this parameter.
-
key_schema(Optional[KeySchema], default:None) –Specifies the attributes that make up the primary key for a table or an index. The attributes in
KeySchemamust also be defined in theAttributeDefinitionsarray. For more information, see Data Model in the Amazon DynamoDB Developer Guide.Each
KeySchemaElementin 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
KeyTypeofHASH.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
KeyTypeofHASH, and the second element must have aKeyTypeofRANGE.For more information, see Working with Tables in the Amazon DynamoDB Developer Guide.
-
-
local_secondary_indexes(Optional[LocalSecondaryIndexList], default:None) –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 inNonKeyAttributes. -
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 inNonKeyAttributes, 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. This limit only applies when you specify the ProjectionType ofINCLUDE. You still can specify the ProjectionType ofALLto project all attributes from the source table, even if the table has more than 100 attributes.
-
-
-
global_secondary_indexes(Optional[GlobalSecondaryIndexList], default:None) –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. Each global secondary index supports up to 4 partition keys and up to 4 sort keys. -
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 inNonKeyAttributes. -
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 inNonKeyAttributes, 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. This limit only applies when you specify the ProjectionType ofINCLUDE. You still can specify the ProjectionType ofALLto project all attributes from the source table, even if the table has more than 100 attributes.
-
-
ProvisionedThroughput- The provisioned throughput settings for the global secondary index, consisting of read and write capacity units.
-
-
billing_mode(Optional[BillingMode], default:None) –Controls how you are charged for read and write throughput and how you manage capacity. This setting can be changed later.
-
PAY_PER_REQUEST- We recommend usingPAY_PER_REQUESTfor most DynamoDB workloads.PAY_PER_REQUESTsets the billing mode to On-demand capacity mode. -
PROVISIONED- We recommend usingPROVISIONEDfor steady workloads with predictable growth where capacity requirements can be reliably forecasted.PROVISIONEDsets the billing mode to Provisioned capacity mode.
-
-
provisioned_throughput(Optional[ProvisionedThroughput], default:None) –Represents the provisioned throughput settings for a specified table or index. The settings can be modified using the
UpdateTableoperation.If you set BillingMode as
PROVISIONED, you must specify this property. If you set BillingMode asPAY_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.
-
stream_specification(Optional[StreamSpecification], default:None) –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,StreamViewTypedetermines what information is written to the table's stream. Valid values forStreamViewTypeare:-
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.
-
-
-
sse_specification(Optional[SSESpecification], default:None) –Represents the settings used to enable server-side encryption.
-
tags(Optional[TagList], default:None) –A list of key-value pairs to label the table. For more information, see Tagging for DynamoDB.
-
table_class(Optional[TableClass], default:None) –The table class of the new table. Valid values are
STANDARDandSTANDARD_INFREQUENT_ACCESS. -
deletion_protection_enabled(Optional[DeletionProtectionEnabled], default:None) –Indicates whether deletion protection is to be enabled (true) or disabled (false) on the table.
-
warm_throughput(Optional[WarmThroughput], default:None) –Represents the warm throughput (in read units per second and write units per second) for creating a table.
-
resource_policy(Optional[ResourcePolicy], default:None) –An Amazon Web Services resource-based policy document in JSON format that will be attached to the table.
When you attach a resource-based policy while creating a table, the policy application is strongly consistent.
The maximum size supported for a resource-based policy document is 20 KB. DynamoDB counts whitespaces when calculating the size of a policy against this limit. For a full list of all considerations that apply for resource-based policies, see Resource-based policy considerations.
You need to specify the
CreateTableandPutResourcePolicyIAM actions for authorizing a user to create a table with a resource-based policy. -
on_demand_throughput(Optional[OnDemandThroughput], default:None) –Sets the maximum number of read and write units for the specified table in on-demand capacity mode. If you use this parameter, you must specify
MaxReadRequestUnits,MaxWriteRequestUnits, or both. -
global_table_source_arn(Optional[TableArn], default:None) –The Amazon Resource Name (ARN) of the source table used for the creation of a multi-account global table.
-
global_table_settings_replication_mode(Optional[GlobalTableSettingsReplicationMode], default:None) –Controls the settings synchronization mode for the global table. For multi-account global tables, this parameter is required and the only supported value is ENABLED. For same-account global tables, this parameter is set to ENABLED_WITH_OVERRIDES.
-
vector_indexes(Optional[VectorIndexList], default:None) –One or more vector indexes to be created on the table. Each vector index enables similarity search on a vector attribute. Each element in the list consists of:
-
IndexName- The name of the vector index. Must be unique within the table. -
VectorAttribute- The attribute that contains vector embeddings. If multiple vector indexes reference the same attribute, they must all use the same number of dimensions. -
Dimensions- The number of dimensions in each vector. -
DistanceFunction- The distance function used to calculate similarity. Valid values:COSINE,EUCLIDEAN,DOT_PRODUCT. -
Projection- Specifies attributes that are copied (projected) from the table into the vector index. The total number of projected non-key attributes is shared across the vector attribute (counts as 1) andINLINE_FILTERsearch schema elements (each counts as 1).HASHsearch schema elements do not count toward this limit. -
SearchSchema- (Optional) Defines the partition key (HASH) and inline filter (INLINE_FILTER) attributes for the vector index.
-
Raises:
-
InternalServerError–An error occurred on the server side.
-
LimitExceededException–There is no limit to the number of daily on-demand backups that can be taken.
For most purposes, up to 500 simultaneous table operations are allowed per account. These operations include
CreateTable,UpdateTable,DeleteTable,UpdateTimeToLive,RestoreTableFromBackup, andRestoreTableToPointInTime.When you are creating a table with one or more secondary indexes, you can have up to 250 such requests running at a time. However, if the table or index specifications are complex, then DynamoDB might temporarily reduce the number of concurrent operations.
When importing into DynamoDB, up to 50 simultaneous import table operations are allowed per account.
There is a soft account quota of 2,500 tables.
GetRecords was called with a value of more than 1000 for the limit request parameter.
More than 2 processes are reading from the same streams shard at the same time. Exceeding this limit may result in request throttling.
-
ResourceInUseException–The operation conflicts with the resource's availability. For example:
-
You attempted to recreate an existing table.
-
You tried to delete a table currently in the
CREATINGstate. -
You tried to update a resource that was already being updated.
When appropriate, wait for the ongoing update to complete and attempt the request again.
-
-
UnknownServiceError–The service returned an error code this client does not model.
Source code in docs_src/capo_dynamodb/_services/dynamo_db.py
677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 | |