Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

Change time-based partition key granularity from day to month

julesbertrand
Level 2
Level 2
Change time-based partition key granularity from day to month

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

0 Kudos
1 Reply
AmandaM
Dataiker
Dataiker

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.

0 Kudos