Google BigQuery — List all partitions in a partitioned table

Suresh Kumar
Jul 19, 2018

Partitioned table

A partitioned table is a special table that is divided into segments, called partitions, that makes it easier to manage and query your data. By dividing a large table into smaller partitions, you can improve query performance, and you can control costs by reducing the number of bytes read by a query.

There are two types of table partitioning available in BigQuery:

  • Tables partitioned by ingestion time: Tables partitioned based on the data’s ingestion (load) date or arrival date.
  • Partitioned tables: Tables that are partitioned based on a TIMESTAMP or DATE column.

This article has been moved to

Visit to continue reading