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 & モバイルアプリケーション統合分析

タグ

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?

関連するコンテンツ