Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Creating roles in AWS with access to the S3 storage required for external locations.

Proposed Solution

• Create Terraform script or CLI command to create an AWS role with the proper S3 access.
• Triggered by [FEATURE]: Create cloud principals for table access based on role mapping #912

Additional Context

No response