Hi, when creating tables or mat view, what are the best practices on the number of buckets ? Should we specify it or not mention it and let starrocks create the right number of buckets? Is there some rules to follow for facts and dimensions tables and their respective number of buckets. Thank you

In most case you want to explicitly mention the bucket count in your create table statements. In general, you want to make each of your tablet within 1 - 10gb in size. https://docs.starrocks.io/docs/best_practices/partitioning/#partitioning-vs-bucketingdifferent-jobs