topic Re: Configuration of NCC for Serverless to access SQL server running in a Azure VM in Administration & Architecture

Configuration of NCC for Serverless to access SQL server running in a Azure VM

Veilraj — Wed, 23 Oct 2024 11:29:28 GMT

Hi Team,

I am following this link to configure NCC for a Serverless compute to access a SQL Server running in a Azure VM.

https://learn.microsoft.com/en-us/azure/databricks/security/network/serverless-network-security/

This references to adding private endpoints only to Blob. Do we have anything which supports allowing secure access to a VM?

Re: Configuration of NCC for Serverless to access SQL server running in a Azure VM

shhhhhh — Wed, 29 Jan 2025 00:20:31 GMT

also interested in doing this. Have federated queries for Classic Databricks cluster pointing to SQL server, but can't find documentation for Serverless plane connecting to SQL server on a VM

Re: Configuration of NCC for Serverless to access SQL server running in a Azure VM

Rjdudley — Wed, 29 Jan 2025 14:07:02 GMT

Lakehouse Federation was built for these scenarios, https://learn.microsoft.com/en-us/azure/databricks/query-federation/.

Since Serverless Compute technically runs in Databricks' cloud estate, you would need to set up cross-account permissions, which requires configuration on both ends, and you don't have the permissions to edit Databricks' side. Nor are they going to allow that.