Change time-based partition key granularity from day to month

julesbertrand

Hi Dataïku,

I have a dataset partitioned by day that I want to re-partition by month. What's the best way of doing it please ? I tried an INSERT OVERWRITE table PARTITION () but is there a better way ?

Thanks,

Jules

---

Operating system used: MacOS

AmandaM

Hi @julesbertrand
-

You can change the partition from day to month by going into the dataset settings, navigating to the Partitioning Tab, and changing the period from MONTH to DAY as seen in the screenshot below. You can find more information about partitioning in the knowledge base article here.