Using Appsync with Redshift?

We use Redshift extensively and want to implement a GraphQL API in front of reporting tables. I can't see an obvious way of using Appsync for this, without creating a middleware layer in e.g. lambda. I'm hoping I'm missing something, because being able to do this by config in Appsync would be brilliant!

主题: 分析无服务器应用程序集成前端 Web 和移动
标签: 亚马逊云科技应用同步亚马逊 Redshift
语言: English

AWS-User-2532670

已提问 5 年前1881 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

Hi,

I regret to inform that it is not currently possible to integrate Appsync directly with Redshift. We can find the list of supported Datasources and operations here in our Appsync Documentation

As you have already mentioned, you would need to use a Lambda function in the middle to use Appsync with Redshift. I hope this helps. Please let us know if you may have any other questions for us.

支持工程师

Ryan_A

已回答 5 年前

专家

Fabrizio

已审核 4 年前

AWS-User-2532670
5 年前
Thanks Ryan, much appreciated and very clear. Have you got any links to design patterns/ tutorials to get us on the right path?
Ryan_A 支持工程师
4 年前
Hi,

Thanks for your reply. I have checked out our documentation and blogs but unfortunately it does not look like we have a tutorial that covers an Appsync -> Lambda -> Redshift integration. I would recommend starting with these 2 separate links to get you started

Appsync -> Lambda tutorial https://docs.aws.amazon.com/appsync/latest/devguide/tutorial-lambda-resolvers.html

Lambda -> Redshift blog post https://aws.amazon.com/blogs/big-data/building-an-event-driven-application-with-aws-lambda-and-the-amazon-redshift-data-api/

In the blog, you can replace the Amazon Eventbridge with Appsync as the trigger to the Lambda function. I do hope this helps you get started.

Using Appsync with Redshift?

添加回答

相关内容