Level 7 - ArchitectDebugging Questionsm3 partitioning lifecycle
Debug Cast Preventing Partition Pruning
Fix query: SELECT COUNT(*) FROM events WHERE CAST(event_time AS DATE) = CURRENT_DATE;
Schema Context
events(event_id, event_time) -- partitioned by event_time