Hoew to get static IP address from synapse anlytics workspace to share with 3rd party vender for white listing

Question

Hi,
We re trying to access the sftp server from synapse analytics workspace, writing a python notebook to connect sftp server . But we are not able to connect due to restriction on firewall from sftp server end, they are asking to provide an static IP address so that they can whitelist it and we can connect.

Could someone will help us , how to get the static IP address from synapse analytics workspace?

Your quick response would be highly appreciated.

Regards
Sanjeev

Answer 1

Hi Sanjeev Nayak and welcome to the QnA forum

In the following link you can get the list of Azure SQL Database and Azure Synapse Analytics Gateway IP addresses

https://learn.microsoft.com/azure/azure-sql/database/connectivity-architecture?view=azuresql&WT.mc_id=DP-MVP-5001699#gateway-ip-addresses

With that said, here is a good tip for these who can control the firewall and need to open it for specific IP for one-time-use (I am using this trick a lot especially during lectures in events):

Try to connect -> get the exact error and get the specific IP which you have for your service right now (this IP can be changed but it is what is used now) -> and open only this specific IP for better security

I hope that this covers you needs :-)