'copy data from on premise sql server to delta format in Azure Data Lake Storage Gen2
I have a copy activity that copy on premise sql data to parquet format in data lake gen2. But I need to copy sql data to delta format in the same data lake. I tried using the data flow to copy from parquet to delta but we have performance issues in this approach. Is there any other way we can achieve this?
Solution 1:[1]
We have different tools to accomplish the required task.
- The Copy Data tool
- The Azure portal
- The .NET SDK
- The Python SDK
- Azure PowerShell
- The REST API
- The Azure Resource Manager template
The major requirement is to make perfect configuration regarding access tokens and authentication.
Check the above link for the procedure.
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 | SairamTadepalli-MT |