Copying delta to Azure SQL DB.

[KVNARK]

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 · Accepted solution]

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)

[Aviral-Bhardwaj]

this is good details

[Ajay-Pandey]

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

[Aviral-Bhardwaj]

amazing , never seen this before,thanks

[KVNARK]

@Ajay Pandey​ is this recently introduced in Azure?

[Ajay-Pandey]

Yes,

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

[KVNARK]

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