The important factors deciding partition columns are:

• Even distribution of data.
• Choose the column that is commonly or widely accessed or queried.
• Do not create multiple levels of partition, as you can end up with a large number of small files.