What should be the ideal number of partitions for a Kraft based kafka cluster of 3 brokers and 3 controllers.
The consumer application consumes it into snowflake using the latest snowflake’s snowpipe streaming.

Is it a good idea to have it in the multiples of 3 like 9 or 12 partitions having 3-4 partitions per broker in this architecture?
Kindly advise as I’m a but confused in choosing the partition number.