How to convert ADF Pipeline Run Id (string) to GUID?

Question

I have a table in a SQL database with a UNIQUEIDENTIFIER data type

I would like to populate this table with the Pipeline Run Id parameter in Azure Data Factory

When I pass this parameter, it is passed as a string value, my table in the SQL database expects a value GUID() value. Is there a way to convert the parameter to GUID() type. Or should I consider changing the datatype in the target table?

Thanks in advance :)

Answer 1

You'll probably be better served by changing the SQL data type to a varchar if that's possible. Pipelines don't have a variable type for guid. They also do not have a conversion function for string to guid. The guid() function generates a new guid value but returns a string. The Data Flow expression language doesn't even contain a reference to guid. All in all, my conclusion is if you can just treat them as strings you should.