Cross region Databricks to SQL Connection

[Dbks_Community]

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. ?​

[Aviral-Bhardwaj]

this you can achieve via IAM role and IAM users

[Cedric]

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