topic Re: Databrick notebook to Azure SQL server connection using private ip because Public access is Denied in Azure SQL database, and Databrick and Azure SQL both in same subscription but different Virtual Network. in Data Engineering

Databrick notebook to Azure SQL server connection using private ip because Public access is Denied in Azure SQL database, and Databrick and Azure SQL both in same subscription but different Virtual Network.

Databrick_begin — Wed, 14 Dec 2022 17:07:10 GMT

We have created private endpoint for Azure SQL database which has private ip. and by making host file entry in my system i am able to resolve Ip for Azure sql server from my system and connect to Server. but unable to connect from Azure Databrick notebook because it is not resolving the IP address. We have peering in place between Databrick VNET and Azure SQLPrivate endpoint Vnet. Looking for Approach to connect Databrick notebook to Azure SQL database.

Re: Databrick notebook to Azure SQL server connection using private ip because Public access is Denied in Azure SQL database, and Databrick and Azure SQL both in same subscription but different Virtual Network.

Ryoma — Thu, 02 Mar 2023 05:05:32 GMT

If vnet injection is not used, the connection could be established by setting up an init script with azure private resolver as nameserver.

#!/bin/bash

mv /etc/resolv.conf /etc/resolv.conf.orig

echo nameserver <your dns server ip> | sudo tee --append /etc/resolv.conf