Amazon Keyspaces

2022/03/02 - Amazon Keyspaces - 13 new api methods

Changes  This release adds support for data definition language (DDL) operations

UpdateTable (new) Link ¶

Adds new columns to the table or updates one of the table's settings, for example capacity mode, encryption, point-in-time recovery, or ttl settings. Note that you can only update one specific table setting per update operation.

See also: AWS API Documentation

Request Syntax

client.update_table(
    keyspaceName='string',
    tableName='string',
    addColumns=[
        {
            'name': 'string',
            'type': 'string'
        },
    ],
    capacitySpecification={
        'throughputMode': 'PAY_PER_REQUEST'|'PROVISIONED',
        'readCapacityUnits': 123,
        'writeCapacityUnits': 123
    },
    encryptionSpecification={
        'type': 'CUSTOMER_MANAGED_KMS_KEY'|'AWS_OWNED_KMS_KEY',
        'kmsKeyIdentifier': 'string'
    },
    pointInTimeRecovery={
        'status': 'ENABLED'|'DISABLED'
    },
    ttl={
        'status': 'ENABLED'
    },
    defaultTimeToLive=123
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace the specified table is stored in.

type tableName

string

param tableName

[REQUIRED]

The name of the table.

type addColumns

list

param addColumns

For each column to be added to the specified table:

  • name - The name of the column.

  • type - An Amazon Keyspaces data type. For more information, see Data types in the Amazon Keyspaces Developer Guide .

  • (dict) --

    The names and data types of regular columns.

    • name (string) -- [REQUIRED]

      The name of the column.

    • type (string) -- [REQUIRED]

      The data type of the column. For a list of available data types, see Data types in the Amazon Keyspaces Developer Guide .

type capacitySpecification

dict

param capacitySpecification

Modifies the read/write throughput capacity mode for the table. The options are:

  • throughputMode:PAY_PER_REQUEST and

  • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

The default is throughput_mode:PAY_PER_REQUEST .

For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • throughputMode (string) -- [REQUIRED]

    The read/write throughput capacity mode for a table. The options are:

    • throughputMode:PAY_PER_REQUEST and

    • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

    The default is throughput_mode:PAY_PER_REQUEST .

    For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • readCapacityUnits (integer) --

    The throughput capacity specified for read operations defined in read capacity units (RCUs) .

  • writeCapacityUnits (integer) --

    The throughput capacity specified for write operations defined in write capacity units (WCUs) .

type encryptionSpecification

dict

param encryptionSpecification

Modifies the encryption settings of the table. You can choose one of the following KMS key (KMS key):

<ul> <li> <p> <code>type:AWS_OWNED_KMS_KEY</code> - This key is owned by Amazon Keyspaces. </p> </li> <li> <p> <code>type:CUSTOMER_MANAGED_KMS_KEY</code> - This key is stored in your account and is created, owned, and managed by you. This option requires the <code>kms_key_identifier</code> of the KMS key in Amazon Resource Name (ARN) format as input. </p> </li> </ul> <p>The default is <code>AWS_OWNED_KMS_KEY</code>. </p> <p>For more information, see <a href="https://docs.aws.amazon.com/keyspaces/latest/devguide/EncryptionAtRest.html">Encryption at rest</a> in the <i>Amazon Keyspaces Developer Guide</i>.</p>

  • type (string) -- [REQUIRED]

    The encryption option specified for the table. You can choose one of the following KMS keys (KMS keys):

    • type:AWS_OWNED_KMS_KEY - This key is owned by Amazon Keyspaces.

    • type:CUSTOMER_MANAGED_KMS_KEY - This key is stored in your account and is created, owned, and managed by you. This option requires the kms_key_identifier of the KMS key in Amazon Resource Name (ARN) format as input.

    The default is type:AWS_OWNED_KMS_KEY .

    For more information, see Encryption at rest in the Amazon Keyspaces Developer Guide .

  • kmsKeyIdentifier (string) --

    The Amazon Resource Name (ARN) of the customer managed KMS key, for example kms_key_identifier:ARN .

type pointInTimeRecovery

dict

param pointInTimeRecovery

Modifies the pointInTimeRecovery settings of the table. The options are:

  • ENABLED

  • DISABLED

If it's not specified, the default is DISABLED .

For more information, see Point-in-time recovery in the Amazon Keyspaces Developer Guide .

  • status (string) -- [REQUIRED]

    The options are:

    • ENABLED

    • DISABLED

type ttl

dict

param ttl

Modifies Time to Live custom settings for the table. The options are:

  • status:enabled

  • status:disabled

The default is status:disabled . After ttl is enabled, you can't disable it for the table.

For more information, see Expiring data by using Amazon Keyspaces Time to Live (TTL) in the Amazon Keyspaces Developer Guide .

  • status (string) -- [REQUIRED]

    Shows how to enable custom Time to Live (TTL) settings for the specified table.

type defaultTimeToLive

integer

param defaultTimeToLive

The default Time to Live setting in seconds for the table.

For more information, see Setting the default TTL value for a table in the Amazon Keyspaces Developer Guide .

rtype

dict

returns

Response Syntax

{
    'resourceArn': 'string'
}

Response Structure

  • (dict) --

    • resourceArn (string) --

      The Amazon Resource Name (ARN) of the modified table.

CreateTable (new) Link ¶

The CreateTable operation adds a new table to the specified keyspace. Within a keyspace, table names must be unique.

CreateTable is an asynchronous operation. When the request is received, the status of the table is set to CREATING . You can monitor the creation status of the new table by using the GetTable operation, which returns the current status of the table. You can start using a table when the status is ACTIVE .

For more information, see Creating tables in the Amazon Keyspaces Developer Guide .

See also: AWS API Documentation

Request Syntax

client.create_table(
    keyspaceName='string',
    tableName='string',
    schemaDefinition={
        'allColumns': [
            {
                'name': 'string',
                'type': 'string'
            },
        ],
        'partitionKeys': [
            {
                'name': 'string'
            },
        ],
        'clusteringKeys': [
            {
                'name': 'string',
                'orderBy': 'ASC'|'DESC'
            },
        ],
        'staticColumns': [
            {
                'name': 'string'
            },
        ]
    },
    comment={
        'message': 'string'
    },
    capacitySpecification={
        'throughputMode': 'PAY_PER_REQUEST'|'PROVISIONED',
        'readCapacityUnits': 123,
        'writeCapacityUnits': 123
    },
    encryptionSpecification={
        'type': 'CUSTOMER_MANAGED_KMS_KEY'|'AWS_OWNED_KMS_KEY',
        'kmsKeyIdentifier': 'string'
    },
    pointInTimeRecovery={
        'status': 'ENABLED'|'DISABLED'
    },
    ttl={
        'status': 'ENABLED'
    },
    defaultTimeToLive=123,
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ]
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace that the table is going to be created in.

type tableName

string

param tableName

[REQUIRED]

The name of the table.

type schemaDefinition

dict

param schemaDefinition

[REQUIRED]

The schemaDefinition consists of the following parameters.

For each column to be created:

  • name - The name of the column.

  • type - An Amazon Keyspaces data type. For more information, see Data types in the Amazon Keyspaces Developer Guide .

<p>The primary key of the table consists of the following columns:</p> <ul> <li> <p> <code>partitionKeys</code> - The partition key can be a single column, or it can be a compound value composed of two or more columns. The partition key portion of the primary key is required and determines how Amazon Keyspaces stores your data.</p> <ul> <li> <p> <i> <code>name</code> </i> - The name of each partition key column.</p> </li> </ul> </li> <li> <p> <code>clusteringKeys</code> - The optional clustering column portion of your primary key determines how the data is clustered and sorted within each partition.</p> <ul> <li> <p> <i> <code>name</code> </i> - The name of the clustering column. </p> </li> <li> <p> <i> <code>orderBy</code> </i> - Sets the ascendant (<code>ASC</code>) or descendant (<code>DESC</code>) order modifier.</p> </li> </ul> </li> </ul> <p>To define a column as static use <code> <i>staticColumns</i> </code> - Static columns store values that are shared by all rows in the same partition:</p> <ul> <li> <p> <i> <code>name</code> </i> - The name of the column.</p> </li> <li> <p> <code> <i>type</i> </code> - An Amazon Keyspaces data type.</p> </li> </ul>

  • allColumns (list) -- [REQUIRED]

    The regular columns of the table.

    • (dict) --

      The names and data types of regular columns.

      • name (string) -- [REQUIRED]

        The name of the column.

      • type (string) -- [REQUIRED]

        The data type of the column. For a list of available data types, see Data types in the Amazon Keyspaces Developer Guide .

  • partitionKeys (list) -- [REQUIRED]

    The columns that are part of the partition key of the table .

    • (dict) --

      The partition key portion of the primary key is required and determines how Amazon Keyspaces stores the data. The partition key can be a single column, or it can be a compound value composed of two or more columns.

      • name (string) -- [REQUIRED]

        The name(s) of the partition key column(s).

  • clusteringKeys (list) --

    The columns that are part of the clustering key of the table.

    • (dict) --

      The optional clustering column portion of your primary key determines how the data is clustered and sorted within each partition.

      • name (string) -- [REQUIRED]

        The name(s) of the clustering column(s).

      • orderBy (string) -- [REQUIRED]

        Sets the ascendant ( ASC ) or descendant ( DESC ) order modifier.

  • staticColumns (list) --

    The columns that have been defined as STATIC . Static columns store values that are shared by all rows in the same partition.

    • (dict) --

      The static columns of the table. Static columns store values that are shared by all rows in the same partition.

      • name (string) -- [REQUIRED]

        The name of the static column.

type comment

dict

param comment

This parameter allows to enter a description of the table.

  • message (string) -- [REQUIRED]

    An optional description of the table.

type capacitySpecification

dict

param capacitySpecification

Specifies the read/write throughput capacity mode for the table. The options are:

  • throughputMode:PAY_PER_REQUEST and

  • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

The default is throughput_mode:PAY_PER_REQUEST .

For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • throughputMode (string) -- [REQUIRED]

    The read/write throughput capacity mode for a table. The options are:

    • throughputMode:PAY_PER_REQUEST and

    • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

    The default is throughput_mode:PAY_PER_REQUEST .

    For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • readCapacityUnits (integer) --

    The throughput capacity specified for read operations defined in read capacity units (RCUs) .

  • writeCapacityUnits (integer) --

    The throughput capacity specified for write operations defined in write capacity units (WCUs) .

type encryptionSpecification

dict

param encryptionSpecification

Specifies how the encryption key for encryption at rest is managed for the table. You can choose one of the following KMS key (KMS key):

<ul> <li> <p> <code>type:AWS_OWNED_KMS_KEY</code> - This key is owned by Amazon Keyspaces. </p> </li> <li> <p> <code>type:CUSTOMER_MANAGED_KMS_KEY</code> - This key is stored in your account and is created, owned, and managed by you. This option requires the <code>kms_key_identifier</code> of the KMS key in Amazon Resource Name (ARN) format as input. </p> </li> </ul> <p>The default is <code>type:AWS_OWNED_KMS_KEY</code>. </p> <p>For more information, see <a href="https://docs.aws.amazon.com/keyspaces/latest/devguide/EncryptionAtRest.html">Encryption at rest</a> in the <i>Amazon Keyspaces Developer Guide</i>.</p>

  • type (string) -- [REQUIRED]

    The encryption option specified for the table. You can choose one of the following KMS keys (KMS keys):

    • type:AWS_OWNED_KMS_KEY - This key is owned by Amazon Keyspaces.

    • type:CUSTOMER_MANAGED_KMS_KEY - This key is stored in your account and is created, owned, and managed by you. This option requires the kms_key_identifier of the KMS key in Amazon Resource Name (ARN) format as input.

    The default is type:AWS_OWNED_KMS_KEY .

    For more information, see Encryption at rest in the Amazon Keyspaces Developer Guide .

  • kmsKeyIdentifier (string) --

    The Amazon Resource Name (ARN) of the customer managed KMS key, for example kms_key_identifier:ARN .

type pointInTimeRecovery

dict

param pointInTimeRecovery

Specifies if pointInTimeRecovery is enabled or disabled for the table. The options are:

  • ENABLED

  • DISABLED

If it's not specified, the default is DISABLED .

For more information, see Point-in-time recovery in the Amazon Keyspaces Developer Guide .

  • status (string) -- [REQUIRED]

    The options are:

    • ENABLED

    • DISABLED

type ttl

dict

param ttl

Enables Time to Live custom settings for the table. The options are:

  • status:enabled

  • status:disabled

The default is status:disabled . After ttl is enabled, you can't disable it for the table.

For more information, see Expiring data by using Amazon Keyspaces Time to Live (TTL) in the Amazon Keyspaces Developer Guide .

  • status (string) -- [REQUIRED]

    Shows how to enable custom Time to Live (TTL) settings for the specified table.

type defaultTimeToLive

integer

param defaultTimeToLive

The default Time to Live setting in seconds for the table.

For more information, see Setting the default TTL value for a table in the Amazon Keyspaces Developer Guide .

type tags

list

param tags

A list of key-value pair tags to be attached to the resource.

For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

  • (dict) --

    Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

    Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

    For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

    • key (string) -- [REQUIRED]

      The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

    • value (string) -- [REQUIRED]

      The value of the tag. Tag values are case-sensitive and can be null.

rtype

dict

returns

Response Syntax

{
    'resourceArn': 'string'
}

Response Structure

  • (dict) --

    • resourceArn (string) --

      The unique identifier of the table in the format of an Amazon Resource Name (ARN).

TagResource (new) Link ¶

Associates a set of tags with a Amazon Keyspaces resource. You can then activate these user-defined tags so that they appear on the Cost Management Console for cost allocation tracking.

For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

See also: AWS API Documentation

Request Syntax

client.tag_resource(
    resourceArn='string',
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ]
)
type resourceArn

string

param resourceArn

[REQUIRED]

The Amazon Resource Name (ARN) of the Amazon Keyspaces resource to which to add tags.

type tags

list

param tags

[REQUIRED]

The tags to be assigned to the Amazon Keyspaces resource.

  • (dict) --

    Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

    Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

    For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

    • key (string) -- [REQUIRED]

      The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

    • value (string) -- [REQUIRED]

      The value of the tag. Tag values are case-sensitive and can be null.

rtype

dict

returns

Response Syntax

{}

Response Structure

  • (dict) --

GetKeyspace (new) Link ¶

Returns the name and the Amazon Resource Name (ARN) of the specified table.

See also: AWS API Documentation

Request Syntax

client.get_keyspace(
    keyspaceName='string'
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace.

rtype

dict

returns

Response Syntax

{
    'keyspaceName': 'string',
    'resourceArn': 'string'
}

Response Structure

  • (dict) --

    • keyspaceName (string) --

      The name of the keyspace.

    • resourceArn (string) --

      The ARN of the keyspace.

ListKeyspaces (new) Link ¶

Returns a list of keyspaces.

See also: AWS API Documentation

Request Syntax

client.list_keyspaces(
    nextToken='string',
    maxResults=123
)
type nextToken

string

param nextToken

The pagination token. To resume pagination, provide the NextToken value as argument of a subsequent API invocation.

type maxResults

integer

param maxResults

The total number of keyspaces to return in the output. If the total number of keyspaces available is more than the value specified, a NextToken is provided in the output. To resume pagination, provide the NextToken value as an argument of a subsequent API invocation.

rtype

dict

returns

Response Syntax

{
    'nextToken': 'string',
    'keyspaces': [
        {
            'keyspaceName': 'string',
            'resourceArn': 'string'
        },
    ]
}

Response Structure

  • (dict) --

    • nextToken (string) --

      A token to specify where to start paginating. This is the NextToken from a previously truncated response.

    • keyspaces (list) --

      A list of keyspaces.

      • (dict) --

        Represents the properties of a keyspace.

        • keyspaceName (string) --

          The name of the keyspace.

        • resourceArn (string) --

          The unique identifier of the keyspace in the format of an Amazon Resource Name (ARN).

DeleteKeyspace (new) Link ¶

The DeleteKeyspace operation deletes a keyspace and all of its tables.

See also: AWS API Documentation

Request Syntax

client.delete_keyspace(
    keyspaceName='string'
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace to be deleted.

rtype

dict

returns

Response Syntax

{}

Response Structure

  • (dict) --

ListTables (new) Link ¶

Returns a list of tables for a specified keyspace.

See also: AWS API Documentation

Request Syntax

client.list_tables(
    nextToken='string',
    maxResults=123,
    keyspaceName='string'
)
type nextToken

string

param nextToken

The pagination token. To resume pagination, provide the NextToken value as an argument of a subsequent API invocation.

type maxResults

integer

param maxResults

The total number of tables to return in the output. If the total number of tables available is more than the value specified, a NextToken is provided in the output. To resume pagination, provide the NextToken value as an argument of a subsequent API invocation.

type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace.

rtype

dict

returns

Response Syntax

{
    'nextToken': 'string',
    'tables': [
        {
            'keyspaceName': 'string',
            'tableName': 'string',
            'resourceArn': 'string'
        },
    ]
}

Response Structure

  • (dict) --

    • nextToken (string) --

      A token to specify where to start paginating. This is the NextToken from a previously truncated response.

    • tables (list) --

      A list of tables.

      • (dict) --

        Returns the name of the specified table, the keyspace it is stored in, and the unique identifier in the format of an Amazon Resource Name (ARN).

        • keyspaceName (string) --

          The name of the keyspace that the table is stored in.

        • tableName (string) --

          The name of the table.

        • resourceArn (string) --

          The unique identifier of the table in the format of an Amazon Resource Name (ARN).

UntagResource (new) Link ¶

Removes the association of tags from a Amazon Keyspaces resource.

See also: AWS API Documentation

Request Syntax

client.untag_resource(
    resourceArn='string',
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ]
)
type resourceArn

string

param resourceArn

[REQUIRED]

The Amazon Keyspaces resource that the tags will be removed from. This value is an Amazon Resource Name (ARN).

type tags

list

param tags

[REQUIRED]

A list of existing tags to be removed from the Amazon Keyspaces resource.

  • (dict) --

    Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

    Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

    For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

    • key (string) -- [REQUIRED]

      The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

    • value (string) -- [REQUIRED]

      The value of the tag. Tag values are case-sensitive and can be null.

rtype

dict

returns

Response Syntax

{}

Response Structure

  • (dict) --

ListTagsForResource (new) Link ¶

Returns a list of all tags associated with the specified Amazon Keyspaces resource.

See also: AWS API Documentation

Request Syntax

client.list_tags_for_resource(
    resourceArn='string',
    nextToken='string',
    maxResults=123
)
type resourceArn

string

param resourceArn

[REQUIRED]

The Amazon Resource Name (ARN) of the Amazon Keyspaces resource.

type nextToken

string

param nextToken

The pagination token. To resume pagination, provide the NextToken value as argument of a subsequent API invocation.

type maxResults

integer

param maxResults

The total number of tags to return in the output. If the total number of tags available is more than the value specified, a NextToken is provided in the output. To resume pagination, provide the NextToken value as an argument of a subsequent API invocation.

rtype

dict

returns

Response Syntax

{
    'nextToken': 'string',
    'tags': [
        {
            'key': 'string',
            'value': 'string'
        },
    ]
}

Response Structure

  • (dict) --

    • nextToken (string) --

      A token to specify where to start paginating. This is the NextToken from a previously truncated response.

    • tags (list) --

      A list of tags.

      • (dict) --

        Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

        Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

        For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

        • key (string) --

          The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

        • value (string) --

          The value of the tag. Tag values are case-sensitive and can be null.

DeleteTable (new) Link ¶

The DeleteTable operation deletes a table and all of its data. After a DeleteTable request is received, the specified table is in the DELETING state until Amazon Keyspaces completes the deletion. If the table is in the ACTIVE state, you can delete it. If a table is either in the CREATING or UPDATING states, then Amazon Keyspaces returns a ResourceInUseException . If the specified table does not exist, Amazon Keyspaces returns a ResourceNotFoundException . If the table is already in the DELETING state, no error is returned.

See also: AWS API Documentation

Request Syntax

client.delete_table(
    keyspaceName='string',
    tableName='string'
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace of the to be deleted table.

type tableName

string

param tableName

[REQUIRED]

The name of the table to be deleted.

rtype

dict

returns

Response Syntax

{}

Response Structure

  • (dict) --

RestoreTable (new) Link ¶

Restores the specified table to the specified point in time within the earliest_restorable_timestamp and the current time. For more information about restore points, see Time window for PITR continuous backups in the Amazon Keyspaces Developer Guide .

Any number of users can execute up to 4 concurrent restores (any type of restore) in a given account.

When you restore using point in time recovery, Amazon Keyspaces restores your source table's schema and data to the state based on the selected timestamp (day:hour:minute:second) to a new table. The Time to Live (TTL) settings are also restored to the state based on the selected timestamp.

In addition to the table's schema, data, and TTL settings, RestoreTable restores the capacity mode, encryption, and point-in-time recovery settings from the source table. Unlike the table's schema data and TTL settings, which are restored based on the selected timestamp, these settings are always restored based on the table's settings as of the current time or when the table was deleted.

You can also overwrite these settings during restore:

  • Read/write capacity mode

  • Provisioned throughput capacity settings

  • Point-in-time (PITR) settings

  • Tags

For more information, see PITR restore settings in the Amazon Keyspaces Developer Guide .

The following settings are not restored, and you must configure them manually for the new table.

  • Automatic scaling policies (for tables that use provisioned capacity mode)

  • Identity and Access Management (IAM) policies

  • Amazon CloudWatch metrics and alarms

See also: AWS API Documentation

Request Syntax

client.restore_table(
    sourceKeyspaceName='string',
    sourceTableName='string',
    targetKeyspaceName='string',
    targetTableName='string',
    restoreTimestamp=datetime(2015, 1, 1),
    capacitySpecificationOverride={
        'throughputMode': 'PAY_PER_REQUEST'|'PROVISIONED',
        'readCapacityUnits': 123,
        'writeCapacityUnits': 123
    },
    encryptionSpecificationOverride={
        'type': 'CUSTOMER_MANAGED_KMS_KEY'|'AWS_OWNED_KMS_KEY',
        'kmsKeyIdentifier': 'string'
    },
    pointInTimeRecoveryOverride={
        'status': 'ENABLED'|'DISABLED'
    },
    tagsOverride=[
        {
            'key': 'string',
            'value': 'string'
        },
    ]
)
type sourceKeyspaceName

string

param sourceKeyspaceName

[REQUIRED]

The keyspace name of the source table.

type sourceTableName

string

param sourceTableName

[REQUIRED]

The name of the source table.

type targetKeyspaceName

string

param targetKeyspaceName

[REQUIRED]

The name of the target keyspace.

type targetTableName

string

param targetTableName

[REQUIRED]

The name of the target table.

type restoreTimestamp

datetime

param restoreTimestamp

The restore timestamp in ISO 8601 format.

type capacitySpecificationOverride

dict

param capacitySpecificationOverride

Specifies the read/write throughput capacity mode for the target table. The options are:

  • throughputMode:PAY_PER_REQUEST and

  • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

The default is throughput_mode:PAY_PER_REQUEST .

For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • throughputMode (string) -- [REQUIRED]

    The read/write throughput capacity mode for a table. The options are:

    • throughputMode:PAY_PER_REQUEST and

    • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

    The default is throughput_mode:PAY_PER_REQUEST .

    For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

  • readCapacityUnits (integer) --

    The throughput capacity specified for read operations defined in read capacity units (RCUs) .

  • writeCapacityUnits (integer) --

    The throughput capacity specified for write operations defined in write capacity units (WCUs) .

type encryptionSpecificationOverride

dict

param encryptionSpecificationOverride

Specifies the encryption settings for the target table. You can choose one of the following KMS key (KMS key):

<ul> <li> <p> <code>type:AWS_OWNED_KMS_KEY</code> - This key is owned by Amazon Keyspaces. </p> </li> <li> <p> <code>type:CUSTOMER_MANAGED_KMS_KEY</code> - This key is stored in your account and is created, owned, and managed by you. This option requires the <code>kms_key_identifier</code> of the KMS key in Amazon Resource Name (ARN) format as input. </p> </li> </ul> <p>The default is <code>type:AWS_OWNED_KMS_KEY</code>. </p> <p>For more information, see <a href="https://docs.aws.amazon.com/keyspaces/latest/devguide/EncryptionAtRest.html">Encryption at rest</a> in the <i>Amazon Keyspaces Developer Guide</i>.</p>

  • type (string) -- [REQUIRED]

    The encryption option specified for the table. You can choose one of the following KMS keys (KMS keys):

    • type:AWS_OWNED_KMS_KEY - This key is owned by Amazon Keyspaces.

    • type:CUSTOMER_MANAGED_KMS_KEY - This key is stored in your account and is created, owned, and managed by you. This option requires the kms_key_identifier of the KMS key in Amazon Resource Name (ARN) format as input.

    The default is type:AWS_OWNED_KMS_KEY .

    For more information, see Encryption at rest in the Amazon Keyspaces Developer Guide .

  • kmsKeyIdentifier (string) --

    The Amazon Resource Name (ARN) of the customer managed KMS key, for example kms_key_identifier:ARN .

type pointInTimeRecoveryOverride

dict

param pointInTimeRecoveryOverride

Specifies the pointInTimeRecovery settings for the target table. The options are:

  • ENABLED

  • DISABLED

If it's not specified, the default is DISABLED .

For more information, see Point-in-time recovery in the Amazon Keyspaces Developer Guide .

  • status (string) -- [REQUIRED]

    The options are:

    • ENABLED

    • DISABLED

type tagsOverride

list

param tagsOverride

A list of key-value pair tags to be attached to the restored table.

For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

  • (dict) --

    Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

    Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

    For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

    • key (string) -- [REQUIRED]

      The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

    • value (string) -- [REQUIRED]

      The value of the tag. Tag values are case-sensitive and can be null.

rtype

dict

returns

Response Syntax

{
    'restoredTableARN': 'string'
}

Response Structure

  • (dict) --

    • restoredTableARN (string) --

      The Amazon Resource Name (ARN) of the restored table.

GetTable (new) Link ¶

Returns information about the table, including the table's name and current status, the keyspace name, configuration settings, and metadata.

See also: AWS API Documentation

Request Syntax

client.get_table(
    keyspaceName='string',
    tableName='string'
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace that the table is stored in.

type tableName

string

param tableName

[REQUIRED]

The name of the table.

rtype

dict

returns

Response Syntax

{
    'keyspaceName': 'string',
    'tableName': 'string',
    'resourceArn': 'string',
    'creationTimestamp': datetime(2015, 1, 1),
    'status': 'ACTIVE'|'CREATING'|'UPDATING'|'DELETING'|'DELETED'|'RESTORING'|'INACCESSIBLE_ENCRYPTION_CREDENTIALS',
    'schemaDefinition': {
        'allColumns': [
            {
                'name': 'string',
                'type': 'string'
            },
        ],
        'partitionKeys': [
            {
                'name': 'string'
            },
        ],
        'clusteringKeys': [
            {
                'name': 'string',
                'orderBy': 'ASC'|'DESC'
            },
        ],
        'staticColumns': [
            {
                'name': 'string'
            },
        ]
    },
    'capacitySpecification': {
        'throughputMode': 'PAY_PER_REQUEST'|'PROVISIONED',
        'readCapacityUnits': 123,
        'writeCapacityUnits': 123,
        'lastUpdateToPayPerRequestTimestamp': datetime(2015, 1, 1)
    },
    'encryptionSpecification': {
        'type': 'CUSTOMER_MANAGED_KMS_KEY'|'AWS_OWNED_KMS_KEY',
        'kmsKeyIdentifier': 'string'
    },
    'pointInTimeRecovery': {
        'status': 'ENABLED'|'DISABLED',
        'earliestRestorableTimestamp': datetime(2015, 1, 1)
    },
    'ttl': {
        'status': 'ENABLED'
    },
    'defaultTimeToLive': 123,
    'comment': {
        'message': 'string'
    }
}

Response Structure

  • (dict) --

    • keyspaceName (string) --

      The name of the keyspace that the specified table is stored in.

    • tableName (string) --

      The name of the specified table.

    • resourceArn (string) --

      The Amazon Resource Name (ARN) of the specified table.

    • creationTimestamp (datetime) --

      The creation timestamp of the specified table.

    • status (string) --

      The current status of the specified table.

    • schemaDefinition (dict) --

      The schema definition of the specified table.

      • allColumns (list) --

        The regular columns of the table.

        • (dict) --

          The names and data types of regular columns.

          • name (string) --

            The name of the column.

          • type (string) --

            The data type of the column. For a list of available data types, see Data types in the Amazon Keyspaces Developer Guide .

      • partitionKeys (list) --

        The columns that are part of the partition key of the table .

        • (dict) --

          The partition key portion of the primary key is required and determines how Amazon Keyspaces stores the data. The partition key can be a single column, or it can be a compound value composed of two or more columns.

          • name (string) --

            The name(s) of the partition key column(s).

      • clusteringKeys (list) --

        The columns that are part of the clustering key of the table.

        • (dict) --

          The optional clustering column portion of your primary key determines how the data is clustered and sorted within each partition.

          • name (string) --

            The name(s) of the clustering column(s).

          • orderBy (string) --

            Sets the ascendant ( ASC ) or descendant ( DESC ) order modifier.

      • staticColumns (list) --

        The columns that have been defined as STATIC . Static columns store values that are shared by all rows in the same partition.

        • (dict) --

          The static columns of the table. Static columns store values that are shared by all rows in the same partition.

          • name (string) --

            The name of the static column.

    • capacitySpecification (dict) --

      The read/write throughput capacity mode for a table. The options are:

      • throughputMode:PAY_PER_REQUEST and

      • throughputMode:PROVISIONED .

      • throughputMode (string) --

        The read/write throughput capacity mode for a table. The options are:

        • throughputMode:PAY_PER_REQUEST and

        • throughputMode:PROVISIONED . The provisioned capacity mode requires readCapacityUnits and writeCapacityUnits as inputs.

        The default is throughput_mode:PAY_PER_REQUEST .

        For more information, see Read/write capacity modes in the Amazon Keyspaces Developer Guide .

      • readCapacityUnits (integer) --

        The throughput capacity specified for read operations defined in read capacity units (RCUs) .

      • writeCapacityUnits (integer) --

        The throughput capacity specified for write operations defined in write capacity units (WCUs) .

      • lastUpdateToPayPerRequestTimestamp (datetime) --

        The timestamp of the last operation that changed the provisioned throughput capacity of a table.

    • encryptionSpecification (dict) --

      The encryption settings of the specified table.

      • type (string) --

        The encryption option specified for the table. You can choose one of the following KMS keys (KMS keys):

        • type:AWS_OWNED_KMS_KEY - This key is owned by Amazon Keyspaces.

        • type:CUSTOMER_MANAGED_KMS_KEY - This key is stored in your account and is created, owned, and managed by you. This option requires the kms_key_identifier of the KMS key in Amazon Resource Name (ARN) format as input.

        The default is type:AWS_OWNED_KMS_KEY .

        For more information, see Encryption at rest in the Amazon Keyspaces Developer Guide .

      • kmsKeyIdentifier (string) --

        The Amazon Resource Name (ARN) of the customer managed KMS key, for example kms_key_identifier:ARN .

    • pointInTimeRecovery (dict) --

      The point-in-time recovery status of the specified table.

      • status (string) --

        Shows if point-in-time recovery is enabled or disabled for the specified table.

      • earliestRestorableTimestamp (datetime) --

        Specifies the earliest possible restore point of the table in ISO 8601 format.

    • ttl (dict) --

      The custom Time to Live settings of the specified table.

      • status (string) --

        Shows how to enable custom Time to Live (TTL) settings for the specified table.

    • defaultTimeToLive (integer) --

      The default Time to Live settings of the specified table.

    • comment (dict) --

      The the description of the specified table.

      • message (string) --

        An optional description of the table.

CreateKeyspace (new) Link ¶

The CreateKeyspace operation adds a new keyspace to your account. In an Amazon Web Services account, keyspace names must be unique within each Region.

CreateKeyspace is an asynchronous operation. You can monitor the creation status of the new keyspace by using the GetKeyspace operation.

For more information, see Creating keyspaces in the Amazon Keyspaces Developer Guide .

See also: AWS API Documentation

Request Syntax

client.create_keyspace(
    keyspaceName='string',
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ]
)
type keyspaceName

string

param keyspaceName

[REQUIRED]

The name of the keyspace to be created.

type tags

list

param tags

A list of key-value pair tags to be attached to the keyspace.

For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

  • (dict) --

    Describes a tag. A tag is a key-value pair. You can add up to 50 tags to a single Amazon Keyspaces resource.

    Amazon Web Services-assigned tag names and values are automatically assigned the aws: prefix, which the user cannot assign. Amazon Web Services-assigned tag names do not count towards the tag limit of 50. User-assigned tag names have the prefix user: in the Cost Allocation Report. You cannot backdate the application of a tag.

    For more information, see Adding tags and labels to Amazon Keyspaces resources in the Amazon Keyspaces Developer Guide .

    • key (string) -- [REQUIRED]

      The key of the tag. Tag keys are case sensitive. Each Amazon Keyspaces resource can only have up to one tag with the same key. If you try to add an existing tag (same key), the existing tag value will be updated to the new value.

    • value (string) -- [REQUIRED]

      The value of the tag. Tag values are case-sensitive and can be null.

rtype

dict

returns

Response Syntax

{
    'resourceArn': 'string'
}

Response Structure

  • (dict) --

    • resourceArn (string) --

      The unique identifier of the keyspace in the format of an Amazon Resource Name (ARN).