Cloud Control resource requests by status

Mutations against Cloud Control backed AWS resources (INSERT, UPDATE, DELETE) are asynchronous: each returns a progress event and completes in the background. This query lists recent requests in a region matching an operation type and status - the entry point for "did my changes complete" and "what failed" asks.

Query

SELECT Identifier, Operation, OperationStatus, StatusMessage, ErrorCode, TypeName, RequestToken, EventTime
FROM awscc.cloud_control.resource_requests
WHERE ResourceRequestStatusFilter = '{"OperationStatuses": ["{{operation_status}}"], "Operations": ["{{operation}}"]}'
AND region = '{{region}}';

Notes

ResourceRequestStatusFilter is a JSON document and both lists accept multiple values - widen the filter by editing it, e.g. '{"OperationStatuses": ["FAILED"], "Operations": ["CREATE", "UPDATE"]}'. Common asks: FAILED CREATE requests after provisioning, SUCCESS UPDATE requests to confirm completion, IN_PROGRESS to see what is still running. An empty result means no matching requests in the region's recent history - completed requests age out. Use the RequestToken with aws/cloud_control/resource-request-by-token to poll a single request.