Using Lakehouse Federation for SQL Server with Serverless Compute

ss_data_eng
New Contributor

Hi,

My team was able to create a Foreign Catalog that connects to a SQL Server instance hosted on an Azure VM, however when trying to query the catalog, we cannot access it using serverless compute (or a serverless sql warehouse). We have tried looking into creating an NCC to connect, however there doesn't seem to be a way to create a Private Link to an Azure VM. How can we allow Databricks Serverless compute to access a SQL Server instance in an Azure VM?