Azure Data Factory - Split file into multiple files based on a Key column

This video takes you through the steps to split one file to multiple files based on the Month value present in a date column.

[vinodkumarkatta]

I don't need, new file to be created after splitting. I need only csv file with filename as one of the column name. Please help me.

[DebjitDubey]

I want that key to be intact on the new generated file. How to do that?

[alaeducation]

I am trying to copy. CSV file having more than one lakh records. One of the column contains date data. In copy activity mapping, it is showing data truncation.

What steps should I take?
Plz help.

[zaidquzmar]

Can we merge parquet files with different structure if file size less then 256m dynamic
Like I just have to determine the folder ?

[swapneelhosur]

I have a SQL View in Synapse Dedicated, which accounts for 1.5 billion records. Is there a way to split this large table into Files derived from Column data? I used Data Flow and it turned out to be pretty slow running for around 3-4 hours. Also, the costing of data flow is expensive than other activities. Is there any other way to split data into files in Azure Synapse?
I also tried inserting the records of view into physical table and using physical table as data source, but to no avail the data flow took around 4-5 hours and failed stating memory issue.