โ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.
โ10-14-2024 10:24 AM
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
โ10-14-2024 10:24 AM
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
โ10-15-2024 11:22 AM
Passionate about hosting events and connecting people? Help us grow a vibrant local communityโsign up today to get started!
Sign Up Now