probably a better question for the SQL or data warehouse community
Although I've seen more times than not that folks use a CREATE TABLE AS SELECT to do what you're describing.
Basically I need to know.
if we have large table with partitions and need to transfer data to new table on a daily basis. then what is the fastest method to do this.
For e.g. Need to insert large data into new table on a daily basis then what is the fastest method.
A partitioning question, better asked the general Database or SQL spaces here.
Do you want to do a copy of the partition or can you partition by day and exchange partitions with the other table?