Connecting to Azure Synapse
Note: PopSQL supports Azure Synapse only as a cloud connection.
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connectionbutton at the top of the connections page.
Azure Synapsefrom the list.
- Give a
Connection namefor your own internal reference.
Hostname, enter the hostname of your database server.
Database, enter the name of your database.
Password, enter the username and password. These are optional.
- Share the connection with your team.
Note: If you encounter an error, make sure that the PopSQL IPs are accepted by the Azure firewall. To do so, from the Azure portal select Firewalls under Security and add a new IP firewall rule. Give it a name, enter the Start IP and the End IP and save.
Happy querying! 🍭
Updated 10 months ago