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!

Themen: Analysen Anwendungsintegration Serverlos Front-End Web & Mobile
Tags: AWS AppSync Amazon Redshift
Sprache: English

AWS-User-2532670

gefragt vor 4 Jahren1879 Aufrufe

1 Antwort

Neueste
Die meisten Stimmen
Die meisten Kommentare

Sind diese Antworten hilfreich? Stimmen Sie der richtigen Antwort zu, damit die Community von Ihrem Wissen profitieren kann.

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.

SUPPORT-TECHNIKER

Ryan_A

beantwortet vor 4 Jahren

EXPERTE

Fabrizio

überprüft vor 4 Jahren

AWS-User-2532670
vor 4 Jahren
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 SUPPORT-TECHNIKER
vor 4 Jahren
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.

Relevanter Inhalt

Wie verwende ich AWS AppSync, um auf private Ressourcen in meiner VPC zuzugreifen?
AWS OFFICIALAktualisiert vor 4 Jahren
Wie behebe ich „Unauthorized“ -Fehler bei der Ausführung von GraphQL-Anfragen in AWS AppSync?
AWS OFFICIALAktualisiert vor 2 Jahren
Wie informiere ich AWS AppSync-Subscriber über externe Datenbank-Updates, dass clientseitige Mutationen nicht funktionieren?
AWS OFFICIALAktualisiert vor 3 Jahren
Wie konfiguriere ich ein AWS AppSync-Schema für den Umgang mit verschachtelten JSON-Daten in DynamoDB?
AWS OFFICIALAktualisiert vor 4 Jahren

Using Appsync with Redshift?

Füge deine Antwort hinzu

Relevanter Inhalt