Copying delta to Azure SQL DB.

KVNARK
Honored Contributor II

‎12-22-2022 05:22 AM

How to copy DELTA to AZURE SQL DB using ADF?

Earlier we are using parquet format. Now, We have converted parquet to Delta by using below command:

CONVERT TO DELTA parquet.path (Azure Blob Path)

daniel_sahal
Databricks MVP

‎12-22-2022 05:44 AM

You can use Azure Databricks Delta Lake linked service

(https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-databricks-delta-lake?tabs=data-factory)

or source directly from Blob using Mapping data flow (https://learn.microsoft.com/en-us/azure/data-factory/format-delta)

View solution in original post

Aviral-Bhardwaj
Esteemed Contributor III

‎12-22-2022 07:38 PM

this is good details

AviralBhardwaj

Ajay-Pandey
Databricks MVP

‎12-22-2022 08:08 PM

Hi @Aviral Bhardwaj​ in ADF there is an option of a delta lake file you can directly save your file in delta lake format.

image

Ajay Kumar Pandey
Preview file
42 KB

Aviral-Bhardwaj
Esteemed Contributor III
In response to Ajay-Pandey

‎12-22-2022 08:25 PM

amazing , never seen this before,thanks

AviralBhardwaj
0 Kudos

KVNARK
Honored Contributor II
In response to Ajay-Pandey

‎12-22-2022 08:37 PM

@Ajay Pandey​ is this recently introduced in Azure?

0 Kudos

Ajay-Pandey
Databricks MVP
In response to KVNARK

‎12-22-2022 08:50 PM

Yes,

Now you directly write data using azure databricks delta lake connector.

Ajay Kumar Pandey

KVNARK
Honored Contributor II
In response to KVNARK

‎12-22-2022 08:53 PM

wow. great feature. Thanks a lot for letting the group know!!!

0 Kudos