Rename Oracle Table

[dansnyder]

I have created a workflow that runs weekly to overwrite data in an Oracle database table. Before writing the output to Oracle each week, I would like to rename the current version of the table with today's date appended, so we can look back at the output through time. I believe this is possible in SQL with a RENAME TABLE query, but I cannot figure out how to do this in an Alteryx workflow.

[ImadZidan · Accepted solution]

Hello @dansnyder ,

Have you tried to explored the below option in the outputData tool.

Look at the Pre Create SQL statement. It is possible to have you RENAME command there.

Have a look.

[dansnyder]

This is what I was looking for, thank you!