Support SNS-backed CloudFormation Custom Resources

[flostadler]

Hello!

• Vote on this issue by adding a 👍 reaction
• If you want to implement this feature, comment to let us know (we'll work with you on design, scheduling, etc.)

Issue details

This issue is for gauging interest in SNS-backed CloudFormation Custom Resources. Right now, the provider only support Lambda-backed Custom Resources because they are more widely used.

More details can be seen in the AWS docs.

Affected area/feature