Google BigQuery — List all partitions in a partitioned table

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 sureshdsk.dev

Visit https://sureshdsk.dev/google-bigquery-list-all-partitions-in-a-partitioned-table to continue reading