1. Instead of using many small partitions (e.g., country or region), opt for larger partitions, such as continent or time-based partitions (e.g., weekly or monthly). This will reduce the number of partitions and improve performance.
2. Write data to a staging table without partitions and periodically merge it into the main partitioned table as needed.
3. Consider using dynamic partition pruning to ensure that only relevant partitions are read during queries.
