VNet Gateway with Azure Databricks SQL Warehouse

[saikrishna_ch]

We are experiencing issues with the VNet Gateway integration with Azure Databricks SQL Warehouse, which is resulting in frequent gateway mashup and locking conflicts errors. The root cause appears to be the simultaneous import of data in import mode and concurrent reads, leading to conflicts. Can you suggest an optimal solution to resolve this issue?

[saikrishna_ch]

direct query has latency issues, import is required for the dashboard scope.

[v-denglli-msft]

Hi @saikrishna_ch ,

VNet gateways allow import or direct query semantic models to connect to data services within an Azure virtual network.

You can try to connect in Direct Query mode.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.