fix(warehouse): change ClickHouse partition from daily to monthly by deepshekhardas · Pull Request #6669 · rudderlabs/rudder-server

…dderlabs#5079)

Changed PARTITION BY from toDate() to toYYYYMM() in ClickHouse table creation.

This follows ClickHouse best practices recommending partitions of 30-150GB. Monthly partitions are more appropriate for typical rudder-server workloads.

Closes rudderlabs#5079