Skip to main content

refresh_schemas_status

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

Overview

Namerefresh_schemas_status
TypeResource
Idaws.dms.refresh_schemas_status

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
endpoint_arnstringThe Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
last_failure_messagestringThe last failure message for the schema.
last_refresh_datestring (date-time)The date the schema was last refreshed.
replication_instance_arnstringThe Amazon Resource Name (ARN) of the replication instance.
statusstringThe status of the schema. (successful, failed, refreshing)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_refresh_schemas_statusselectregionReturns the status of the RefreshSchemas operation.

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.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Returns the status of the RefreshSchemas operation.

SELECT
endpoint_arn,
last_failure_message,
last_refresh_date,
replication_instance_arn,
status
FROM aws.dms.refresh_schemas_status
WHERE region = '{{ region }}' -- required
;