as Data loading is a continuous process we are expecting high volume data in future. t will be difficult to create these partition in advance , hence I was planning to have 10 partitions now and as on data get added for each 1 millions it will add on a new parttion range and go on .

Is it possible?