topic Re: adding Widget as a column and populating its value every-time in that column in a table. in Data Engineering

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

sonali1996 — Fri, 20 Jan 2023 04:06:40 GMT

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.

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

Anonymous — Fri, 20 Jan 2023 12:11:49 GMT

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.

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

sher — Sun, 22 Jan 2023 12:30:27 GMT

you can use as current_timestamp() or now()

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