Add waiters to the GetStatementResultResponse of RedshiftData Client

[hugoncosta]

Describe the feature

Hello,

I've seen that for a few Redshift operations, you provide waiters (e.g. DescribeClustersRequest) to avoid us having to do that on our side. On the other hand, this doesn't exist for other operations that also involve waiting, like DescribeStatementRequest (when you make a SQL statement, this will tell you the status of that operation), forcing us to do our own waiter. Would it be possible to add it to all the Redshift operations?

Is your feature request related to a problem?

Not necessarily

Proposed Solution

Do the same waiters as already existing in other Redshift ops.

Describe alternative solutions or features you've considered

No response

Acknowledge

• I may be able to implement this feature request

AWS SDK for Kotlin version

All

Platform (JVM/JS/Native)

Jvm

Operating system and version

Jvm

[lauzadis]

The following waiter will be automatically recommended to the Redshift team the next time they make a model update:

{
  "version": 2,
  "waiters": {
    "StatementFinished": {
      "operation": "DescribeStatement",
      "delay": 30,
      "maxAttempts": 60,
      "acceptors": [
        {
          "state": "success",
          "matcher": "pathAll",
          "argument": "SubStatements[].Status",
          "expected": "FINISHED"
        },
        {
          "state": "failure",
          "matcher": "pathAny",
          "argument": "SubStatements[].Status",
          "expected": "ABORTED"
        },
        {
          "state": "failure",
          "matcher": "pathAny",
          "argument": "SubStatements[].Status",
          "expected": "FAILED"
        }
      ]
    }
  }
}