Amazon Aurora DSQL

2026/11/16 - Amazon Aurora DSQL - 3 updated api methods

Changes  Added support for Amazon Aurora DSQL advanced monitoring metric groups, which publish detailed database metrics and logs to Amazon CloudWatch Database Insights. Adds the metricGroups parameter to CreateCluster, UpdateCluster, and GetCluster.

CreateCluster (updated) Link ¶
Changes (both)
{'metricGroups': [{'metricGroup': 'STATEMENT_STATISTICS'}]}

The CreateCluster API allows you to create both single-Region clusters and multi-Region clusters. With the addition of the multiRegionProperties parameter, you can create a cluster with witness Region support and establish peer relationships with clusters in other Regions during creation.

Required permissions

dsql:CreateCluster

Required to create a cluster.

Resources: arn:aws:dsql:region:account-id:cluster/*

dsql:TagResource

Permission to add tags to a resource.

Resources: arn:aws:dsql:region:account-id:cluster/*

dsql:PutMultiRegionProperties

Permission to configure multi-Region properties for a cluster.

Resources: arn:aws:dsql:region:account-id:cluster/*

dsql:AddPeerCluster

When specifying multiRegionProperties.clusters, permission to add peer clusters.

Resources:

  • Local cluster: arn:aws:dsql:region:account-id:cluster/*

  • Each peer cluster: exact ARN of each specified peer cluster

    dsql:PutWitnessRegion

When specifying multiRegionProperties.witnessRegion, permission to set a witness Region. This permission is checked both in the cluster Region and in the witness Region.

Resources: arn:aws:dsql:region:account-id:cluster/*

Condition Keys: dsql:WitnessRegion (matching the specified witness region)

See also: AWS API Documentation

Request Syntax

client.create_cluster(
    deletionProtectionEnabled=True|False,
    kmsEncryptionKey='string',
    tags={
        'string': 'string'
    },
    clientToken='string',
    multiRegionProperties={
        'witnessRegion': 'string',
        'clusters': [
            'string',
        ]
    },
    policy='string',
    metricGroups=[
        {
            'metricGroup': 'STATEMENT_STATISTICS'
        },
    ],
    bypassPolicyLockoutSafetyCheck=True|False
)
type deletionProtectionEnabled:

boolean

param deletionProtectionEnabled:

If enabled, you can't delete your cluster. You must first disable this property before you can delete your cluster.

type kmsEncryptionKey:

string

param kmsEncryptionKey:

The KMS key that encrypts and protects the data on your cluster. You can specify the ARN, ID, or alias of an existing key or have Amazon Web Services create a default key for you.

type tags:

dict

param tags:

A map of key and value pairs to use to tag your cluster.

  • (string) --

    Unique tag key, maximum 128 Unicode characters in UTF-8.

    • (string) --

      Tag value, maximum 256 Unicode characters in UTF-8.

type clientToken:

string

param clientToken:

A unique, case-sensitive identifier that you provide to ensure the idempotency of the request. Idempotency ensures that an API request completes only once. With an idempotent request, if the original request completes successfully, the subsequent retries with the same client token return the result from the original successful request and they have no additional effect.

If you don't specify a client token, the Amazon Web Services SDK automatically generates one.

This field is autopopulated if not provided.

type multiRegionProperties:

dict

param multiRegionProperties:

The configuration settings when creating a multi-Region cluster, including the witness region and linked cluster properties.

  • witnessRegion (string) --

    The Region that serves as the witness region for a multi-Region cluster. The witness Region helps maintain cluster consistency and quorum.

  • clusters (list) --

    The set of peered clusters that form the multi-Region cluster configuration. Each peered cluster represents a database instance in a different Region.

    • (string) --

      The Amazon Resource Name of the cluster.

type policy:

string

param policy:

An optional resource-based policy document in JSON format that defines access permissions for the cluster.

type metricGroups:

list

param metricGroups:

The metric groups to enable for advanced monitoring on the cluster. Advanced monitoring collects detailed, query-level database metrics to help you analyze and resolve performance issues. If you omit this parameter, no metric groups are enabled.

  • (dict) --

    A metric group to enable for advanced monitoring.

    • metricGroup (string) -- [REQUIRED]

      The name of the metric group to enable.

type bypassPolicyLockoutSafetyCheck:

boolean

param bypassPolicyLockoutSafetyCheck:

An optional field that controls whether to bypass the lockout prevention check. When set to true, this parameter allows you to apply a policy that might lock you out of the cluster. Use with caution.

rtype:

dict

returns:

Response Syntax

{
    'identifier': 'string',
    'arn': 'string',
    'status': 'CREATING'|'ACTIVE'|'IDLE'|'INACTIVE'|'UPDATING'|'DELETING'|'DELETED'|'FAILED'|'PENDING_SETUP'|'PENDING_DELETE',
    'creationTime': datetime(2015, 1, 1),
    'multiRegionProperties': {
        'witnessRegion': 'string',
        'clusters': [
            'string',
        ]
    },
    'encryptionDetails': {
        'encryptionType': 'AWS_OWNED_KMS_KEY'|'CUSTOMER_MANAGED_KMS_KEY',
        'kmsKeyArn': 'string',
        'encryptionStatus': 'ENABLED'|'UPDATING'|'KMS_KEY_INACCESSIBLE'|'ENABLING'
    },
    'deletionProtectionEnabled': True|False,
    'endpoint': 'string',
    'metricGroups': [
        {
            'metricGroup': 'STATEMENT_STATISTICS'
        },
    ]
}

Response Structure

  • (dict) --

    The output of a created cluster.

    • identifier (string) --

      The ID of the created cluster.

    • arn (string) --

      The ARN of the created cluster.

    • status (string) --

      The status of the created cluster.

    • creationTime (datetime) --

      The time of when created the cluster.

    • multiRegionProperties (dict) --

      The multi-Region cluster configuration details that were set during cluster creation

      • witnessRegion (string) --

        The Region that serves as the witness region for a multi-Region cluster. The witness Region helps maintain cluster consistency and quorum.

      • clusters (list) --

        The set of peered clusters that form the multi-Region cluster configuration. Each peered cluster represents a database instance in a different Region.

        • (string) --

          The Amazon Resource Name of the cluster.

    • encryptionDetails (dict) --

      The encryption configuration for the cluster that was specified during the creation process, including the KMS key identifier and encryption state.

      • encryptionType (string) --

        The type of encryption that protects the data on your cluster.

      • kmsKeyArn (string) --

        The ARN of the KMS key that encrypts data in the cluster.

      • encryptionStatus (string) --

        The status of encryption for the cluster.

    • deletionProtectionEnabled (boolean) --

      Whether deletion protection is enabled on this cluster.

    • endpoint (string) --

      The connection endpoint for the created cluster.

    • metricGroups (list) --

      The metric groups that you enabled for advanced monitoring on the created cluster.

      • (dict) --

        A metric group that you enabled for advanced monitoring on a cluster.

        • metricGroup (string) --

          The name of the metric group that you enabled.

GetCluster (updated) Link ¶
Changes (response)
{'metricGroups': [{'metricGroup': 'STATEMENT_STATISTICS'}]}

Retrieves information about a cluster.

See also: AWS API Documentation

Request Syntax

client.get_cluster(
    identifier='string'
)
type identifier:

string

param identifier:

[REQUIRED]

The ID of the cluster to retrieve.

rtype:

dict

returns:

Response Syntax

{
    'identifier': 'string',
    'arn': 'string',
    'status': 'CREATING'|'ACTIVE'|'IDLE'|'INACTIVE'|'UPDATING'|'DELETING'|'DELETED'|'FAILED'|'PENDING_SETUP'|'PENDING_DELETE',
    'creationTime': datetime(2015, 1, 1),
    'deletionProtectionEnabled': True|False,
    'multiRegionProperties': {
        'witnessRegion': 'string',
        'clusters': [
            'string',
        ]
    },
    'tags': {
        'string': 'string'
    },
    'encryptionDetails': {
        'encryptionType': 'AWS_OWNED_KMS_KEY'|'CUSTOMER_MANAGED_KMS_KEY',
        'kmsKeyArn': 'string',
        'encryptionStatus': 'ENABLED'|'UPDATING'|'KMS_KEY_INACCESSIBLE'|'ENABLING'
    },
    'endpoint': 'string',
    'metricGroups': [
        {
            'metricGroup': 'STATEMENT_STATISTICS'
        },
    ]
}

Response Structure

  • (dict) --

    The output of a cluster.

    • identifier (string) --

      The ID of the retrieved cluster.

    • arn (string) --

      The ARN of the retrieved cluster.

    • status (string) --

      The status of the retrieved cluster.

    • creationTime (datetime) --

      The time of when the cluster was created.

    • deletionProtectionEnabled (boolean) --

      Whether deletion protection is enabled in this cluster.

    • multiRegionProperties (dict) --

      Returns the current multi-Region cluster configuration, including witness region and linked cluster information.

      • witnessRegion (string) --

        The Region that serves as the witness region for a multi-Region cluster. The witness Region helps maintain cluster consistency and quorum.

      • clusters (list) --

        The set of peered clusters that form the multi-Region cluster configuration. Each peered cluster represents a database instance in a different Region.

        • (string) --

          The Amazon Resource Name of the cluster.

    • tags (dict) --

      Map of tags.

      • (string) --

        Unique tag key, maximum 128 Unicode characters in UTF-8.

        • (string) --

          Tag value, maximum 256 Unicode characters in UTF-8.

    • encryptionDetails (dict) --

      The current encryption configuration details for the cluster.

      • encryptionType (string) --

        The type of encryption that protects the data on your cluster.

      • kmsKeyArn (string) --

        The ARN of the KMS key that encrypts data in the cluster.

      • encryptionStatus (string) --

        The status of encryption for the cluster.

    • endpoint (string) --

      The connection endpoint for the cluster.

    • metricGroups (list) --

      The metric groups that you enabled for advanced monitoring on the cluster. If you haven't enabled any metric groups, the list is empty.

      • (dict) --

        A metric group that you enabled for advanced monitoring on a cluster.

        • metricGroup (string) --

          The name of the metric group that you enabled.

UpdateCluster (updated) Link ¶
Changes (request)
{'metricGroups': [{'metricGroup': 'STATEMENT_STATISTICS'}]}

The UpdateCluster API allows you to modify both single-Region and multi-Region cluster configurations. With the multiRegionProperties parameter, you can add or modify witness Region support and manage peer relationships with clusters in other Regions.

Required permissions

dsql:UpdateCluster

Permission to update a DSQL cluster.

Resources: arn:aws:dsql:region:account-id:cluster/cluster-id

dsql:PutMultiRegionProperties

Permission to configure multi-Region properties for a cluster.

Resources: arn:aws:dsql:region:account-id:cluster/cluster-id

dsql:GetCluster

Permission to retrieve cluster information.

Resources: arn:aws:dsql:region:account-id:cluster/cluster-id

dsql:AddPeerCluster

Permission to add peer clusters.

Resources:

  • Local cluster: arn:aws:dsql:region:account-id:cluster/cluster-id

  • Each peer cluster: exact ARN of each specified peer cluster

    dsql:RemovePeerCluster

Permission to remove peer clusters. When you list peer clusters in multiRegionProperties.clusters, you need this permission for each current peer cluster that your list omits.

Resources:

  • Each removed peer cluster: exact ARN of each removed peer cluster, in its own Region

    dsql:PutWitnessRegion

Permission to set a witness Region.

Resources: arn:aws:dsql:region:account-id:cluster/cluster-id

Condition Keys: dsql:WitnessRegion (matching the specified witness Region)

This permission is checked both in the cluster Region and in the witness Region.

See also: AWS API Documentation

Request Syntax

client.update_cluster(
    identifier='string',
    deletionProtectionEnabled=True|False,
    kmsEncryptionKey='string',
    clientToken='string',
    multiRegionProperties={
        'witnessRegion': 'string',
        'clusters': [
            'string',
        ]
    },
    metricGroups=[
        {
            'metricGroup': 'STATEMENT_STATISTICS'
        },
    ]
)
type identifier:

string

param identifier:

[REQUIRED]

The ID of the cluster you want to update.

type deletionProtectionEnabled:

boolean

param deletionProtectionEnabled:

Specifies whether to enable deletion protection in your cluster.

type kmsEncryptionKey:

string

param kmsEncryptionKey:

The KMS key that encrypts and protects the data on your cluster. You can specify the ARN, ID, or alias of an existing key or have Amazon Web Services create a default key for you.

To switch to the key owned by Amazon Web Services, specify the reserved value AWS_OWNED_KMS_KEY.

type clientToken:

string

param clientToken:

A unique, case-sensitive identifier that you provide to ensure the idempotency of the request. Idempotency ensures that an API request completes only once. With an idempotent request, if the original request completes successfully. The subsequent retries with the same client token return the result from the original successful request and they have no additional effect.

If you don't specify a client token, the Amazon Web Services SDK automatically generates one.

This field is autopopulated if not provided.

type multiRegionProperties:

dict

param multiRegionProperties:

The new multi-Region cluster configuration settings to be applied during an update operation.

  • witnessRegion (string) --

    The Region that serves as the witness region for a multi-Region cluster. The witness Region helps maintain cluster consistency and quorum.

  • clusters (list) --

    The set of peered clusters that form the multi-Region cluster configuration. Each peered cluster represents a database instance in a different Region.

    • (string) --

      The Amazon Resource Name of the cluster.

type metricGroups:

list

param metricGroups:

The complete set of metric groups to enable for advanced monitoring on the cluster. This list replaces the current set, so any metric group that you don't include is disabled. To disable all metric groups, specify an empty list ( []). If you omit this parameter, the current setting doesn't change.

To view the metric groups enabled on a cluster, use GetCluster.

  • (dict) --

    A metric group to enable for advanced monitoring.

    • metricGroup (string) -- [REQUIRED]

      The name of the metric group to enable.

rtype:

dict

returns:

Response Syntax

{
    'identifier': 'string',
    'arn': 'string',
    'status': 'CREATING'|'ACTIVE'|'IDLE'|'INACTIVE'|'UPDATING'|'DELETING'|'DELETED'|'FAILED'|'PENDING_SETUP'|'PENDING_DELETE',
    'creationTime': datetime(2015, 1, 1)
}

Response Structure

  • (dict) --

    The details of the cluster after it has been updated.

    • identifier (string) --

      The ID of the cluster to update.

    • arn (string) --

      The ARN of the updated cluster.

    • status (string) --

      The status of the updated cluster.

    • creationTime (datetime) --

      The time of when the cluster was created.