I have a pipeline in an Azure DataFactory context. This pipeline has a dataset which is a metadata table and this metadata table needs to be updated regularly. I can update the table using a query in a lookup activity.
The column I need to update contains the date of the last trigger. So, I would like to ask if is there any way of getting the current date as a parameter in the pipeline. If so, I could insert the parameter in my query and update the table.
Thank you in advance.