How do we get the filename prefix maintained in sick? Like filename1_ProductID_NA_760_0.txt. Also, in your example, how did you achieve sql_SalesLT_Product_ProductID_NA_760_0.txt? Can you help telling me about sink details you provided?
Can you please make a video for a source system like db2 where these options won't show up in the copy activity. But if we have a very big table, what will be the better approach for such scenario?
![Bulk Copy from SQL DB to Data Lake Parquet using Azure Data Factory [ADF]](/img/n.gif)
Just a small help , for all kind of I/O errors /connection timeout errors you can use CONNECTIONTIMEOUT in your DB string, this works for ADF.
when it is talking about MPP it is not recommended to have more than 60 partitions
Thank you for your awesome tutorials, could you provide the sink parameters please as it is not shown in the video please?
How do we get the filename prefix maintained in sick? Like filename1_ProductID_NA_760_0.txt. Also, in your example, how did you achieve sql_SalesLT_Product_ProductID_NA_760_0.txt? Can you help telling me about sink details you provided?
What settings did you used in sink to do multiple writes?
Very nice explanation however partitions are not working for I/O exception errors in ADF.
Sorry payal, i doubt I understand what you say 🫣 could u pls provide some details abt what io error we talk abt
Can you please make a video for a source system like db2 where these options won't show up in the copy activity. But if we have a very big table, what will be the better approach for such scenario?
Nice mam