cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
New Contributor

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.

1 REPLY 1

Ryoma
New Contributor II

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group