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.