get the metadata of a csv file by skipping the first two rows

Question

I have a csv file where i have the schema in the 3rd row.
I need to get the columns names only(metadata) from the csv file by skipping the first and second row.

Answer 1

Hi @Dheeraj Kumar Reddy Jogi ,

Thank you for posting query in Microsoft Q&A Platform.

As I understand ask here, you are trying to get schema of your csv file in azure data factory. Please correct me if I am wrong.

This can be done using GetMetaData activity. We can leverage skip line count field to skip starting unwanted rows. Use Structure as Field List inside GetMetaData activity.

Please check below screenshots and details for better idea.

My source file:

Dataset for csv file in ADF:

GetMetaData activity to get structure of csv file:

Output json of GetMetaData activity:

Hope this helps. Please let us know if any further queries.

----------------

Please consider hitting Accept Answer. Accepted answers helps community as well.