โ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.
โ06-06-2024 05:11 AM
Hi @shadowinc, You can use private endpoints in Azure Data Factory (ADF) to securely access Delta tables. These private endpoints allow communication between ADF and services like Azure Blob storage and Azu...1.
Here are the steps to set it up:
Create a Data Factory:
Prepare Your Blob Storage and SQL Database:
emp.txt
file) to the blob storage.dbo.emp
).Configure Linked Services:
Or Use Azure SQL Managed Instance:
Let me know if you need further assistance! ๐
โ08-06-2024 03:58 AM
@Kaniz_Fatma 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.
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