In BigQuery, BigQuery supports multiple partitioning types to optimize query performance and reduce scan costs. Ingestion-time partitioning automatically partitions data based on when rows are loaded into the table. Date or time-unit column partitioning divides data using a DATE, TIMESTAMP, or DATETIME column such as daily, monthly, or yearly partitions. Integer-range partitioning splits tables into ranges based on numeric column values, useful for IDs or numeric categories. These partitioning methods help BigQuery scan only relevant partitions instead of the full table, improving speed and lowering costs.