REST API for Redshift

• Write an AWS Lambda function (in either Node.js, Java or Python)
• Have the function connect to the Amazon Redshift database and perform an SQL call
• Define an API Gateway API that receives the REST request and forwards it to the Lambda function

API Gateway also has the ability to cache responses, which can provide faster performance by not always connecting to Amazon Redshift (eg for recently accessed or slow-changing data).

https://docs.aws.amazon.com/apigateway/latest/developerguide/getting-started-aws-proxy.html

https://docs.aws.amazon.com/apigateway/latest/developerguide/api-gateway-caching.html