I have the D365 F&O data from data lake to synapses via linked services. The data is stored in .csv format and header is stored in another format as .cdm.json, when am querying the .csv file am unable to see the column names instead its showing C1,C2..etc . How can I create a view which show the entity name and data in one single table . I have already deployed CDMUtil and created an azure function will that help?
I have created an Azure function but not sure how to use it , is there any pipeline template to view the .csv data and .cdm.jason data in a view
