adding Widget as a column and populating its value every-time in that column in a table.

[sonali1996]

hi ,

I want date for runtime from ADF as @utcnow() -- base paramater of notebook activity in ADF and take the data in ADB using widgets as runtime_date,

further i want that column to be added in my table X with the populated value from the widget.

Every time the widget col runtime_date value will change whenever my pipeline run.

I am struggling with the idea that how can i add a column which will have runtime_date value everytime.

[Anonymous]

There is a built in function current_timestamp() that you can cast as a date and that should be very close to what you're looking for.

[sher]

you can use as current_timestamp() or now()

refer link: https://docs.databricks.com/sql/language-manual/functions/current_timestamp.html