cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

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

sonali1996
New Contributor

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.

2 REPLIES 2

Anonymous
Not applicable

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
Valued Contributor II

you can use as current_timestamp() or now()

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