How can we get the dynamic name of the output file in u-sql in the azure data lake based on the timestamp task

Question

as we have a dynamic name of the output file in u-sql in the Azure data lake based on the timestamp when the task is running. Thanks for the help. My code is as below:

OUTPUT @telDataResult TO @"wasb:// [e-mail] /**yyyymmdd**_TelDataOutput.Csv" USING Outputters.Csv(); 

Answer 1

This feature is currently under development, but not yet available. Feel free to add your vote to the feature request: https://feedback.azure.com/forums/327234-data-lake/suggestions/10550388-support-dynamic-output-file-names-in-adla

Once it becomes available, you will invert the syntax of the file set into EXTRACT. Suppose you have a column called eventdate in your @res . Then the following OUTPUT statement will generate the files:

 OUTPUT @res TO "/{eventdate:yyyy}/{eventdate:MM}/{eventdate:dd}/result.csv" USING Outputters.Csv();