conversion_configurations

Creates, updates, deletes, gets or lists a conversion_configurations resource.

Overview

Name	conversion_configurations
Type	Resource
Id	aws.dms.conversion_configurations

Fields

The following fields are returned by SELECT queries:

describe_conversion_configuration

Name	Datatype	Description
conversion_configuration	string	A JSON string that contains the schema conversion settings for the migration project. For the format and available settings, see Specifying schema conversion settings for migration projects.
migration_project_identifier	string	The name or Amazon Resource Name (ARN) for the schema conversion project.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_conversion_configuration	select	region		Returns configuration parameters for a schema conversion project. Required permissions: dms:DescribeConversionConfiguration. For more information, see Actions, resources, and condition keys for Database Migration Service.
modify_conversion_configuration	update	region, MigrationProjectIdentifier, ConversionConfiguration		Modifies the specified schema conversion configuration using the provided parameters. Required permissions: dms:UpdateConversionConfiguration. For more information, see Actions, resources, and condition keys for Database Migration Service.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

describe_conversion_configuration

Returns configuration parameters for a schema conversion project. Required permissions: dms:DescribeConversionConfiguration. For more information, see Actions, resources, and condition keys for Database Migration Service.

SELECT
conversion_configuration,
migration_project_identifier
FROM aws.dms.conversion_configurations
WHERE region = '{{ region }}' -- required
;

UPDATE examples

modify_conversion_configuration

Modifies the specified schema conversion configuration using the provided parameters. Required permissions: dms:UpdateConversionConfiguration. For more information, see Actions, resources, and condition keys for Database Migration Service.

UPDATE aws.dms.conversion_configurations
SET 
MigrationProjectIdentifier = '{{ MigrationProjectIdentifier }}',
ConversionConfiguration = '{{ ConversionConfiguration }}'
WHERE 
region = '{{ region }}' --required
AND MigrationProjectIdentifier = '{{ MigrationProjectIdentifier }}' --required
AND ConversionConfiguration = '{{ ConversionConfiguration }}' --required
RETURNING
migration_project_identifier;