2 Answers
- Newest
- Most votes
- Most comments
1
- Redshift supports data sharing where a Serverless cluster can act as a data producer and share data with other clusters or applications.
- You can create IAM roles with necessary permissions to allow external applications controlled access to specific databases/schemas in the Serverless cluster.
- Applications like Power BI can be configured to access the Serverless cluster using IAM credentials associated with the assigned role. This provides a secure way to share data without exposing database credentials.
- For a small number of clients, you can provision individual IAM roles and manage access credentials within your application. Make sure to rotate credentials periodically for security.
- Consider using AWS Secrets Manager to securely store and rotate database credentials for external access. Applications can retrieve secrets at runtime using their assigned IAM role.
0
Good day, Thank You very much
Do you have a best practices link for me to execute, do we expose client data to a view or to a database etc?
answered 2 months ago
Relevant content
- asked 2 years ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago