Azure Data Factory Copy to Parquet file uniqueidentifier

Right now I am haunted by a question regarding copying data from Azure SQL to a parquet file using the azure data factory copy-activity.

The Azure SQL database conains various unqiue_identifier columns. The parquet copy-activity changes those to Strings. This is fine. However since the uniqueidentifier type from the azure sql is not case sensitive it just turns them into lower case stringt.

However we also get those same IDs from other DataSources where they are found directly as capitalized strings.

Now the question is, if there is any way to modify/some kind of setting to change the way how those unique identifiers are transformed into a string (into a upper-case string).

Now this has to be generalized, thus I can’t simply be doing this manually after the fact for every column.

Read more here: Source link