Cross region Databricks to SQL Connection

Dbks_Community
New Contributor II

‎11-30-2022 12:38 PM

We are trying to connect Azure Databricks Cluster to Azure SQL database but the firewalls at SQL level is causing an issue.

Whitelisting dbks subnet is not an option here as both the resources are in two different azure regions. Is there a secure way to achieve this requirement with this architecture. ?​

0 Kudos

Aviral-Bhardwaj
Esteemed Contributor III

‎12-20-2022 06:22 AM

this you can achieve via IAM role and IAM users

AviralBhardwaj
0 Kudos

Cedric
Databricks Employee
Databricks Employee

‎01-27-2023 07:11 AM

Hi @Timir Ranjan​,

Have you tried looking into private endpoints? This allows you to expose your Azure SQL database from the Azure backbone and is cross-regional supported.

https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview

  • Private endpoints enable connectivity between the customers from the same:
    • Virtual network
    • Regionally peered virtual networks
    • Globally peered virtual networks
    • On-premises environments that use VPN or Express Route
    • Services that are powered by Private Link

0 Kudos