'How can we copy 20+ azure sql tables to blob storage in delta format
I used a lookup activity to get the tablenames and then I used a Foreach activity and inside the foreach activities i created a dataflow which will have source as an azure sql dataset and table name will be parameterised and source dataset i created is inline and file type would be json. and in the dataflow parameters i used the parameter for tablename i.e @item.TABLE_NAME
Solution 1:[1]
As per official documentation, Azure Data Factory supports the following file formats. Delta table format is not supported by ADF.
• Avro format
• Binary format
• Delimited text format
• JSON format
• ORC format
• Parquet format
Solution 2:[2]
This should work fine. Are you running into challenges?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | AbhishekKhandave-MT |
| Solution 2 | Mark Kromer MSFT |