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!

主題

無伺服器前端網頁與行動裝置應用程式整合分析

標籤

AWS AppSync Amazon Redshift

語言

English

AWS-User-2532670

已提問 2 年前檢視次數 1205 次

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

已回答 2 年前

專家

Fabrizio@AWS

已審閱 2 年前

AWS-User-2532670
2 年前
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 支援工程師
2 年前
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?

相關內容