feat(events): add dlq support for StepFunction event target

[DaWyz]

Amazon EventBridge recently added support for dead letter queues.

Use Case

It makes event-driven applications more resilient and durable by storing your events in queues when the events can't be delivered, or the target is unavailable. See the documentation for more information.

Proposed Solution

Proposed Solution

Use the same solution as #11612 Issue used for Lambda targets..

• 👋 I may be able to implement this feature request
• ⚠️ This feature might incur a breaking change

---

This is a 🚀 Feature Request

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.