feat: redshift example

[vgkowski]

Issue #, if available:

Description of changes:

Add a new example using Redshift constructs

Checklist

* [x] Update tests * [x] Update docs * [x] PR title follows [conventional commit semantics](https://www.conventionalcommits.org/en/v1.0.0/) (`fix: `, `feat: `, `docs: `, ...) ## Breaking change checklist

RFC issue #:

• [ ] Migration process documented
• [ ] Implement warnings (if it can live side by side)

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.