Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
741 views
in Technique[技术] by (71.8m points)

database - How to authenticate a request to AWS Redshift through IDP with restricted access to S3 data?

Here is the flow: A user will try to authenticate to Redshift, and this auth request should flow over to my personal codebase which has an endpoint that will authenticate this user (this endpoint will act as the IDP). The user should then be able to get access in Redshift only the data from a specific folder inside ONE global S3 bucket. (This bucket contains only folders - one per user, and the user should ONLY access data from within their folder).

How can this be built with AWS? Would we need to use API Gateway or Lambda to forward this request to our codebase's server? How can we narrow down the user's access in Redshift to their specific folder in S3? The data from S3 has to be synced over to Redshift for querying, that is, if anything is added to S3, it should appear in Redshift.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...