[ADF] Redshift connection via SSH tunnel

Question

Is it possible to connect to Amazon Redshift from ADF Linked Service via SSH tunnel?

There is not much information in docs about this:
https://learn.microsoft.com/en-us/azure/data-factory/connector-amazon-redshift?tabs=data-factory#linked-service-properties

Answer 1

Hello @Łukasz Brzozowski ,

Thanks for the question and using MS Q&A platform.

The current ADF Amazon Redshift Connector uses SSL Connection (verify-full sslmode) of Redshift. Hence it is not possible to connect to Amazon Redshift from ADF Redshift Connector via SSH Tunnel.

If you have a feedback/feature request regarding the same, please feel free to log it in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c. All the feedback shared in this forum are actively monitored and reviewed by respective product owners and take action accordingly.

Also please do share the feedback link once it is posted so that other users with similar idea/feedback can up-vote and comment on your suggestion which would help increase the priority of the feature request.

Hope this info helps.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how