23. Session log in copy activity of ADF pipeline

[@CGlassmates]

Thanks🎉☺

[@hritiksharma7154]

Great video. Make such more videos for other activities as well in ADF.

[@HETALVYAS-j2c]

can you tech me to :-Use Azure Data Factory to retrieve data from the Azure Log Analytics API. Use the query language used by Log Analytics (KQL).The sink will be SQL DB. Use conditions like error/Fail .

[@ksenijas4293]

Hi Annu, Do you know how to skip creating logging files when there was no error?

[@kirankumar3536]

Hi Annu, my free subscription was expired and I don't have student id to create student account. Is there any other way to get azure free subscription. Thanks.

[@hritiksharma7154]

Hi Anu , It's bit urgent question. I have one txt file name log_file present in ADLS gen2 storage. I want to daily append the records into this file . What type of changes I need to do in copy activity settings Example 1st day Target src count Target count date Virat. 290. 290. 06-07-2023 2 day Target. src count. Target count. Date Virat 290. 290. 06-07-2023 Virat. 190. 190. 07-07-2023

[@azurecontentannu6399]

Hi it's not possible in file. Appending data is not possible. File can only be overwritten by the next run. Only way to handle this is load every run data into separate file and at the end..use another copy activity pointing to the folder level and use merge files in copy behaviour

[@hritiksharma7154]

@@azurecontentannu6399 thanks for the solution and prompt response.