AWS API Changes

2024/03/18 - Amazon Relational Database Service - 1 new 4 updated api methods

Changes This release launches the ModifyIntegration API and support for data filtering for zero-ETL Integrations.

ModifyIntegration (new)

Modifies a zero-ETL integration with Amazon Redshift.

Note

Currently, you can only modify integrations that have Aurora MySQL source DB clusters. Integrations with Aurora PostgreSQL and RDS sources currently don't support modifying the integration.

See also: AWS API Documentation

Request Syntax

client.modify_integration(
    IntegrationIdentifier='string',
    IntegrationName='string',
    DataFilter='string',
    Description='string'
)

type IntegrationIdentifier

string

param IntegrationIdentifier

[REQUIRED]

The unique identifier of the integration to modify.

type IntegrationName

string

param IntegrationName

A new name for the integration.

type DataFilter

string

param DataFilter

A new data filter for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift .

type Description

string

param Description

A new description for the integration.

rtype

dict

returns

Response Syntax

{
    'SourceArn': 'string',
    'TargetArn': 'string',
    'IntegrationName': 'string',
    'IntegrationArn': 'string',
    'KMSKeyId': 'string',
    'AdditionalEncryptionContext': {
        'string': 'string'
    },
    'Status': 'creating'|'active'|'modifying'|'failed'|'deleting'|'syncing'|'needs_attention',
    'Tags': [
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    'CreateTime': datetime(2015, 1, 1),
    'Errors': [
        {
            'ErrorCode': 'string',
            'ErrorMessage': 'string'
        },
    ],
    'DataFilter': 'string',
    'Description': 'string'
}

Response Structure

(dict) --

A zero-ETL integration with Amazon Redshift.
- SourceArn (string) --
  
  The Amazon Resource Name (ARN) of the database used as the source for replication.
- TargetArn (string) --
  
  The ARN of the Redshift data warehouse used as the target for replication.
- IntegrationName (string) --
  
  The name of the integration.
- IntegrationArn (string) --
  
  The ARN of the integration.
- KMSKeyId (string) --
  
  The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key used to to encrypt the integration.
- AdditionalEncryptionContext (dict) --
  
  The encryption context for the integration. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .
  - (string) --
    - (string) --
- Status (string) --
  
  The current status of the integration.
- Tags (list) --
  
  A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
  - (dict) --
    
    Metadata assigned to an Amazon RDS resource consisting of a key-value pair.
    
    For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
    - Key (string) --
      
      A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
    - Value (string) --
      
      A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
- CreateTime (datetime) --
  
  The time when the integration was created, in Universal Coordinated Time (UTC).
- Errors (list) --
  
  Any errors associated with the integration.
  - (dict) --
    
    An error associated with a zero-ETL integration with Amazon Redshift.
    - ErrorCode (string) --
      
      The error code associated with the integration.
    - ErrorMessage (string) --
      
      A message explaining the error.
- DataFilter (string) --
  
  Data filters for the integration. These filters determine which tables from the source database are sent to the target Amazon Redshift data warehouse.
- Description (string) --
  
  A description of the integration.

CreateIntegration (updated)

Link ¶
Changes (both)

{'DataFilter': 'string', 'Description': 'string'}

Creates a zero-ETL integration with Amazon Redshift.

See also: AWS API Documentation

Request Syntax

client.create_integration(
    SourceArn='string',
    TargetArn='string',
    IntegrationName='string',
    KMSKeyId='string',
    AdditionalEncryptionContext={
        'string': 'string'
    },
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    DataFilter='string',
    Description='string'
)

type SourceArn

string

param SourceArn

[REQUIRED]

The Amazon Resource Name (ARN) of the database to use as the source for replication.

type TargetArn

string

param TargetArn

[REQUIRED]

The ARN of the Redshift data warehouse to use as the target for replication.

type IntegrationName

string

param IntegrationName

[REQUIRED]

The name of the integration.

type KMSKeyId

string

param KMSKeyId

The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key to use to encrypt the integration. If you don't specify an encryption key, RDS uses a default Amazon Web Services owned key.

type AdditionalEncryptionContext

dict

param AdditionalEncryptionContext

An optional set of non-secret key–value pairs that contains additional contextual information about the data. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .

You can only include this parameter if you specify the KMSKeyId parameter.

(string) --
- (string) --

type Tags

list

param Tags

A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.

(dict) --

Metadata assigned to an Amazon RDS resource consisting of a key-value pair.

For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
- Key (string) --
  
  A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
- Value (string) --
  
  A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").

type DataFilter

string

param DataFilter

Data filtering options for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift .

Valid for: Integrations with Aurora MySQL source DB clusters only

type Description

string

param Description

A description of the integration.

rtype

dict

returns

Response Syntax

{
    'SourceArn': 'string',
    'TargetArn': 'string',
    'IntegrationName': 'string',
    'IntegrationArn': 'string',
    'KMSKeyId': 'string',
    'AdditionalEncryptionContext': {
        'string': 'string'
    },
    'Status': 'creating'|'active'|'modifying'|'failed'|'deleting'|'syncing'|'needs_attention',
    'Tags': [
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    'CreateTime': datetime(2015, 1, 1),
    'Errors': [
        {
            'ErrorCode': 'string',
            'ErrorMessage': 'string'
        },
    ],
    'DataFilter': 'string',
    'Description': 'string'
}

Response Structure

(dict) --

A zero-ETL integration with Amazon Redshift.
- SourceArn (string) --
  
  The Amazon Resource Name (ARN) of the database used as the source for replication.
- TargetArn (string) --
  
  The ARN of the Redshift data warehouse used as the target for replication.
- IntegrationName (string) --
  
  The name of the integration.
- IntegrationArn (string) --
  
  The ARN of the integration.
- KMSKeyId (string) --
  
  The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key used to to encrypt the integration.
- AdditionalEncryptionContext (dict) --
  
  The encryption context for the integration. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .
  - (string) --
    - (string) --
- Status (string) --
  
  The current status of the integration.
- Tags (list) --
  
  A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
  - (dict) --
    
    Metadata assigned to an Amazon RDS resource consisting of a key-value pair.
    
    For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
    - Key (string) --
      
      A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
    - Value (string) --
      
      A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
- CreateTime (datetime) --
  
  The time when the integration was created, in Universal Coordinated Time (UTC).
- Errors (list) --
  
  Any errors associated with the integration.
  - (dict) --
    
    An error associated with a zero-ETL integration with Amazon Redshift.
    - ErrorCode (string) --
      
      The error code associated with the integration.
    - ErrorMessage (string) --
      
      A message explaining the error.
- DataFilter (string) --
  
  Data filters for the integration. These filters determine which tables from the source database are sent to the target Amazon Redshift data warehouse.
- Description (string) --
  
  A description of the integration.

DeleteIntegration (updated)

Link ¶
Changes (response)

{'DataFilter': 'string', 'Description': 'string'}

Deletes a zero-ETL integration with Amazon Redshift.

See also: AWS API Documentation

Request Syntax

client.delete_integration(
    IntegrationIdentifier='string'
)

type IntegrationIdentifier

string

param IntegrationIdentifier

[REQUIRED]

The unique identifier of the integration.

rtype

dict

returns

Response Syntax

{
    'SourceArn': 'string',
    'TargetArn': 'string',
    'IntegrationName': 'string',
    'IntegrationArn': 'string',
    'KMSKeyId': 'string',
    'AdditionalEncryptionContext': {
        'string': 'string'
    },
    'Status': 'creating'|'active'|'modifying'|'failed'|'deleting'|'syncing'|'needs_attention',
    'Tags': [
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    'CreateTime': datetime(2015, 1, 1),
    'Errors': [
        {
            'ErrorCode': 'string',
            'ErrorMessage': 'string'
        },
    ],
    'DataFilter': 'string',
    'Description': 'string'
}

Response Structure

(dict) --

A zero-ETL integration with Amazon Redshift.
- SourceArn (string) --
  
  The Amazon Resource Name (ARN) of the database used as the source for replication.
- TargetArn (string) --
  
  The ARN of the Redshift data warehouse used as the target for replication.
- IntegrationName (string) --
  
  The name of the integration.
- IntegrationArn (string) --
  
  The ARN of the integration.
- KMSKeyId (string) --
  
  The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key used to to encrypt the integration.
- AdditionalEncryptionContext (dict) --
  
  The encryption context for the integration. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .
  - (string) --
    - (string) --
- Status (string) --
  
  The current status of the integration.
- Tags (list) --
  
  A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
  - (dict) --
    
    Metadata assigned to an Amazon RDS resource consisting of a key-value pair.
    
    For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
    - Key (string) --
      
      A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
    - Value (string) --
      
      A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
- CreateTime (datetime) --
  
  The time when the integration was created, in Universal Coordinated Time (UTC).
- Errors (list) --
  
  Any errors associated with the integration.
  - (dict) --
    
    An error associated with a zero-ETL integration with Amazon Redshift.
    - ErrorCode (string) --
      
      The error code associated with the integration.
    - ErrorMessage (string) --
      
      A message explaining the error.
- DataFilter (string) --
  
  Data filters for the integration. These filters determine which tables from the source database are sent to the target Amazon Redshift data warehouse.
- Description (string) --
  
  A description of the integration.

DescribeIntegrations (updated)

Link ¶
Changes (response)

{'Integrations': {'DataFilter': 'string', 'Description': 'string'}}

Describe one or more zero-ETL integrations with Amazon Redshift.

See also: AWS API Documentation

Request Syntax

client.describe_integrations(
    IntegrationIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string'
)

type IntegrationIdentifier

string

param IntegrationIdentifier

The unique identifier of the integration.

type Filters

list

param Filters

A filter that specifies one or more resources to return.

(dict) --

A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as IDs. The filters supported by a describe operation are documented with the describe operation.

Note

Currently, wildcards are not supported in filters.

The following actions can be filtered:
- DescribeDBClusterBacktracks
- DescribeDBClusterEndpoints
- DescribeDBClusters
- DescribeDBInstances
- DescribeDBRecommendations
- DescribeDBShardGroups
- DescribePendingMaintenanceActions
- Name (string) -- [REQUIRED]
  
  The name of the filter. Filter names are case-sensitive.
- Values (list) -- [REQUIRED]
  
  One or more filter values. Filter values are case-sensitive.
  - (string) --

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that you can retrieve the remaining results.

Default: 100

Constraints: Minimum 20, maximum 100.

type Marker

string

param Marker

An optional pagination token provided by a previous DescribeIntegrations request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Integrations': [
        {
            'SourceArn': 'string',
            'TargetArn': 'string',
            'IntegrationName': 'string',
            'IntegrationArn': 'string',
            'KMSKeyId': 'string',
            'AdditionalEncryptionContext': {
                'string': 'string'
            },
            'Status': 'creating'|'active'|'modifying'|'failed'|'deleting'|'syncing'|'needs_attention',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ],
            'CreateTime': datetime(2015, 1, 1),
            'Errors': [
                {
                    'ErrorCode': 'string',
                    'ErrorMessage': 'string'
                },
            ],
            'DataFilter': 'string',
            'Description': 'string'
        },
    ]
}

Response Structure

(dict) --
- Marker (string) --
  
  A pagination token that can be used in a later DescribeIntegrations request.
- Integrations (list) --
  
  A list of integrations.
  - (dict) --
    
    A zero-ETL integration with Amazon Redshift.
    - SourceArn (string) --
      
      The Amazon Resource Name (ARN) of the database used as the source for replication.
    - TargetArn (string) --
      
      The ARN of the Redshift data warehouse used as the target for replication.
    - IntegrationName (string) --
      
      The name of the integration.
    - IntegrationArn (string) --
      
      The ARN of the integration.
    - KMSKeyId (string) --
      
      The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key used to to encrypt the integration.
    - AdditionalEncryptionContext (dict) --
      
      The encryption context for the integration. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .
      - (string) --
        
        (string) --
    - Status (string) --
      
      The current status of the integration.
    - Tags (list) --
      
      A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
      - (dict) --
        
        Metadata assigned to an Amazon RDS resource consisting of a key-value pair.
        
        For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
        
        Key (string) --
        
        A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
        
        Value (string) --
        
        A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
    - CreateTime (datetime) --
      
      The time when the integration was created, in Universal Coordinated Time (UTC).
    - Errors (list) --
      
      Any errors associated with the integration.
      - (dict) --
        
        An error associated with a zero-ETL integration with Amazon Redshift.
        
        ErrorCode (string) --
        
        The error code associated with the integration.
        
        ErrorMessage (string) --
        
        A message explaining the error.
    - DataFilter (string) --
      
      Data filters for the integration. These filters determine which tables from the source database are sent to the target Amazon Redshift data warehouse.
    - Description (string) --
      
      A description of the integration.

ModifyIntegration (updated)

Link ¶
Changes (response)

{'DataFilter': 'string', 'Description': 'string'}

Modifies a zero-ETL integration with Amazon Redshift.

Note

Currently, you can only modify integrations that have Aurora MySQL source DB clusters. Integrations with Aurora PostgreSQL and RDS sources currently don't support modifying the integration.

See also: AWS API Documentation

Request Syntax

client.modify_integration(
    IntegrationIdentifier='string',
    IntegrationName='string',
    DataFilter='string',
    Description='string'
)

type IntegrationIdentifier

string

param IntegrationIdentifier

[REQUIRED]

The unique identifier of the integration to modify.

type IntegrationName

string

param IntegrationName

A new name for the integration.

type DataFilter

string

param DataFilter

A new data filter for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift .

type Description

string

param Description

A new description for the integration.

rtype

dict

returns

Response Syntax

{
    'SourceArn': 'string',
    'TargetArn': 'string',
    'IntegrationName': 'string',
    'IntegrationArn': 'string',
    'KMSKeyId': 'string',
    'AdditionalEncryptionContext': {
        'string': 'string'
    },
    'Status': 'creating'|'active'|'modifying'|'failed'|'deleting'|'syncing'|'needs_attention',
    'Tags': [
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    'CreateTime': datetime(2015, 1, 1),
    'Errors': [
        {
            'ErrorCode': 'string',
            'ErrorMessage': 'string'
        },
    ],
    'DataFilter': 'string',
    'Description': 'string'
}

Response Structure

(dict) --

A zero-ETL integration with Amazon Redshift.
- SourceArn (string) --
  
  The Amazon Resource Name (ARN) of the database used as the source for replication.
- TargetArn (string) --
  
  The ARN of the Redshift data warehouse used as the target for replication.
- IntegrationName (string) --
  
  The name of the integration.
- IntegrationArn (string) --
  
  The ARN of the integration.
- KMSKeyId (string) --
  
  The Amazon Web Services Key Management System (Amazon Web Services KMS) key identifier for the key used to to encrypt the integration.
- AdditionalEncryptionContext (dict) --
  
  The encryption context for the integration. For more information, see Encryption context in the Amazon Web Services Key Management Service Developer Guide .
  - (string) --
    - (string) --
- Status (string) --
  
  The current status of the integration.
- Tags (list) --
  
  A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
  - (dict) --
    
    Metadata assigned to an Amazon RDS resource consisting of a key-value pair.
    
    For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.
    - Key (string) --
      
      A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
    - Value (string) --
      
      A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").
- CreateTime (datetime) --
  
  The time when the integration was created, in Universal Coordinated Time (UTC).
- Errors (list) --
  
  Any errors associated with the integration.
  - (dict) --
    
    An error associated with a zero-ETL integration with Amazon Redshift.
    - ErrorCode (string) --
      
      The error code associated with the integration.
    - ErrorMessage (string) --
      
      A message explaining the error.
- DataFilter (string) --
  
  Data filters for the integration. These filters determine which tables from the source database are sent to the target Amazon Redshift data warehouse.
- Description (string) --
  
  A description of the integration.