I'm using Synapse Link for Dataverse to extract data into an Azure Data Lake, but the generated CSV files do not contain proper column names (they use GUIDs instead). I want to create a solution in Azure Data Factory (ADF) that:
- Reads the CSV files from Azure Data Lake (stored under Tables/).
- Replaces the GUID-based column names with their corresponding names
- Converts the transformed data into Parquet format and stores it in a new location in the Data Lake.