Connecting AppSync with Redshift via Data API

Question

Hi,  
  
I'm looking for reasources that exaplin how to connect AppSync with Redshift via Data API.  
According to this, it should be supported: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html  
  
However, I did not see Redshift as an option when defining a Data Source in AppSync.  
Do you know if we need to use a Lambda to bridge between AppSync and Redshift, or is there support for a direct connection?  
  
Thanks,  
Ilan

IlanZilber · Answer

I reached out to AWS Support and received this response:  
"As of now, AppSync is not able to integrate with Redshift directly and you would need to have a Lambda function to bridge between AppSync and Redshift. A list of the supported Datasources and operations can be found here \[2]. However, since this is documentation \[1] is mentioning that it is possible, I will reach out to the service team to confirm if this is an issue with the documentations and will get back to you as soon as I hear back from them."  
And this followup:  
"I have reached out the AppSync service team and confirmed that there is no direct way to integrate with Data API of Redshift, there is currently a feature request regarding that, but we do not have any ETA on when this feature will be released."

edunaway · Answer

Is it still true that Redshift cannot be directly used with AppSync?
 
This announcement still implies it can be done.
* https://aws.amazon.com/about-aws/whats-new/2020/09/announcing-data-api-for-amazon-redshift/

Connecting AppSync with Redshift via Data API

Relevant content