<ul><li>In BigQuery, ingestion-time partitioning automatically divides a table into partitions based on the date and time the data was loaded.</li><li>Unlike column-based partitioning, ingestion-time partitioning in BigQuery happens automatically without needing a specific date column.</li><li>Key system-defined columns in BigQuery for ingestion-time partitioning include _PARTITIONTIME and _PARTITIONDATE.</li><li>Use _PARTITIONTIME for fine-grained time filtering and _PARTITIONDATE for query optimization in ingestion-time partitioned tables.</li></ul>

Ingestion-Time Partitioning in BigQuery

Discover more