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!
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.
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.
Relevant questions
How to achieve multiple Graphql endpoints
asked 4 months agoUsing Appsync with Redshift?
asked 4 months agoStrict transport security header on appsync responses
asked 2 months agoRedshift as as Data Source for a REST API for Analytics Query
Accepted Answerasked 3 years agoConnecting AppSync with Redshift via Data API
asked a year agoHow to implement a Dataloader with Appsync when using Serverless Aurora as a datasource?
asked 5 months agoCan we use both GraphQL and REST API in the same project?
asked a year agoAppSync authorization
Accepted Answerasked 3 years agoNeptune supports Neo4j GraphQL?
asked 3 days agoHow do I set up an AWS Amplify project to query an existing AWS AppSync API?
asked 2 months ago
Thanks Ryan, much appreciated and very clear. Have you got any links to design patterns/ tutorials to get us on the right path?