I have a table that requires an additional column with the current date added. I realize that I can't do this using the CSV importer...How can I do that in a query? I tried standard SQL with UPSERT instead of INSERT:
UPSERT INTO NG.BARS_CNC_DETAILS_HIST SET PULL_DATE=CURRENT_DATE(); but this gives a syntax error.
