2024/03/18 - Amazon Relational Database Service - 1 new4 updated api methods
Changes This release launches the ModifyIntegration API and support for data filtering for zero-ETL Integrations.
Modifies a zero-ETL integration with Amazon Redshift.
See also: AWS API Documentation
Request Syntax
client.modify_integration(
IntegrationIdentifier='string',
IntegrationName='string',
DataFilter='string',
Description='string'
)
string
[REQUIRED]
The unique identifier of the integration to modify.
string
A new name for the integration.
string
A new data filter for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift.
string
A new description for the integration.
dict
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.
{'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'
)
string
[REQUIRED]
The Amazon Resource Name (ARN) of the database to use as the source for replication.
string
[REQUIRED]
The ARN of the Redshift data warehouse to use as the target for replication.
string
[REQUIRED]
The name of the integration.
string
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.
dict
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) --
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}_.:/=+\-@]*)$").
string
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
string
A description of the integration.
dict
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.
{'DataFilter': 'string', 'Description': 'string'}
Deletes a zero-ETL integration with Amazon Redshift.
See also: AWS API Documentation
Request Syntax
client.delete_integration(
IntegrationIdentifier='string'
)
string
[REQUIRED]
The unique identifier of the integration.
dict
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.
{'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'
)
string
The unique identifier of the integration.
list
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.
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) --
integer
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.
string
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.
dict
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.
{'DataFilter': 'string', 'Description': 'string'}
Modifies a zero-ETL integration with Amazon Redshift.
See also: AWS API Documentation
Request Syntax
client.modify_integration(
IntegrationIdentifier='string',
IntegrationName='string',
DataFilter='string',
Description='string'
)
string
[REQUIRED]
The unique identifier of the integration to modify.
string
A new name for the integration.
string
A new data filter for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift.
string
A new description for the integration.
dict
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.