Partitioning splits a large table into physical subsets according to the value of a column, most often a date. A query that filters on this column only reads the relevant partitions, which reduces the volume scanned, the execution time and the cost. The choice of column should reflect the most frequent filters.
Example
CREATE TABLE evenements PARTITION BY DATE(horodatage) AS SELECT * FROM brut.evenements;