Thanks for your input Paul.

My case also similar. I have 1.6 billion rows in that table. New partition key also same as your partition key format. But I don't have any Index on the existing table.

choosing option#2 is costlier for me because every insert stream I start has to do FTS on the existing table. So, I still believe option#1 is feasible for me.

Appreciate your input.

Thanks,