โ06-03-2024 06:16 AM - edited โ06-03-2024 07:07 AM
We have a special endpoint that grants access to delta tables and we want to know if we can use SQL endpoints as a linked service in ADF.
If yes then which ADF-linked service would be suitable for this?
Appreciate your support on this.
โ08-06-2024 01:14 AM
I have not tried this first hand however, from what I know, you have 2 options here.
Hope this helps.
a month ago
Azure Databricks Delta Lake (Dataset) uses a linked service that can only connect to a All Purpose/Interactive cluster.
If you want to use the SQL Endpoint, you would need a Self Hosted Integration Runtime for ADF with Databricks ODBC driver Installed on it. In ADF, the linked service would be a ODBC Linked Service
โ08-06-2024 03:58 AM
@Retired_mod Thanks for the information, however, this query was about the Databricks SQL endpoint (which is like an engine to execute queries in Databricks)
โ08-05-2024 02:58 AM
Hi.
The topic is about databricks sql endpoint as a source using ADF and not Azure SQL.
Best
โ08-06-2024 01:14 AM
I have not tried this first hand however, from what I know, you have 2 options here.
Hope this helps.
โ08-06-2024 02:31 AM
Adf does not support adb sql endpoint as linked server.
โ09-30-2024 01:40 AM - edited โ09-30-2024 01:41 AM
a month ago
Azure Databricks Delta Lake (Dataset) uses a linked service that can only connect to a All Purpose/Interactive cluster.
If you want to use the SQL Endpoint, you would need a Self Hosted Integration Runtime for ADF with Databricks ODBC driver Installed on it. In ADF, the linked service would be a ODBC Linked Service
a month ago
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group