Hi all, ideally it is a best practice to partition a table, or there is some case which is not recommended?

Hi Lucas! It depends on the size of the dataset and what values you have available to partition on, but generally speaking you can get performance improvements via partitions or Z-ordering. E.g. if you tend to access your data in a way where the records retrieved are clustered in time, then partitioning on day or month would probably improve performance.

Each file should be 1gb in size and each partition about 10-50gb. Be careful about overpartitioning