I am looking to make a copy of a very large table from SQL Teradata (80 columns millions of rows) and append 'YYQ#' (for example _23Q2) to the table name monthly for historical backups.
I have a workflow that does this using Teradata bulk but it is taking about 10 minutes and I have 8 tables. I am hoping there is a faster way.
Input -> Formula to create the date as a column -> Output using that column to append. I can quickly make a copy of the table using PreSQL and the output tool is great at appending to the table name, but I don't know how to put the two together because of the calculation that is needed.
I thought I could create the copy with the appended date with 1 row and then insert using another input tool, but I run into the same issue that the appended date will be different each quarter.
Thank you
