refresh_schemas_status
Creates, updates, deletes, gets or lists a refresh_schemas_status resource.
Overview
| Name | refresh_schemas_status |
| Type | Resource |
| Id | aws.dms.refresh_schemas_status |
Fields
The following fields are returned by SELECT queries:
- describe_refresh_schemas_status
| Name | Datatype | Description |
|---|---|---|
endpoint_arn | string | The Amazon Resource Name (ARN) string that uniquely identifies the endpoint. |
last_failure_message | string | The last failure message for the schema. |
last_refresh_date | string (date-time) | The date the schema was last refreshed. |
replication_instance_arn | string | The Amazon Resource Name (ARN) of the replication instance. |
status | string | The status of the schema. (successful, failed, refreshing) |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
describe_refresh_schemas_status | select | region | Returns 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.
| Name | Datatype | Description |
|---|---|---|
region | string | AWS region (default: us-east-1) |
SELECT examples
- describe_refresh_schemas_status
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
;