How to add _BATCH_LAST_RUN_ to the dataflow built with SQL

user095063
user095063 Member
in Charting

Hello,

I am trying to find a way to add BATCH_LAST_RUN column to one of the datasets I have created. I found A way - s to change replace method to append. In this particular dataset, I am grabbing the last 7 days' worth of data, so I need to replace the whole dataset on each run.


Is there any way to add this column with replace method fro SQL dataflow?


Thank you!

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    You can use the GETDATE() function to generate the current date and time in Microsoft's SQL

    SELECT GETDATE() AS Batch_Last_Run

    FROM tablename


    If you are using MySQL, you would use CURRENT_TIMESTAMP

    SELECT CURRENT_TIMESTAMP() AS Batch_Last_Run

    FROM tablename

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories