PartitionsList
Lists the partitioning definitions for tables.
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the table partition, which typically includes the partition key and the partition value. This helps distinguish each partition within the table. |
| ProjectId | String | The ID of the Google Cloud project that owns the table containing the partitioned data. |
| DatasetId | String | The ID of the BigQuery dataset where the partitioned table is located. |
| TableName | String | The name of the BigQuery table that is partitioned. This table contains multiple partitions based on the specified column. |
| ColumnName | String | The name of the column that is used to define partitions in the table. This is typically a date or integer field. |
| ColumnType | String | The data type of the column used for partitioning. Common values include DATE, INTEGER, or TIMESTAMP depending on the partitioning strategy. |
| Kind | String | The method of partitioning applied to the table. Options include DATE (partitioned by date field), RANGE (partitioned by numeric ranges), or INGESTION (partitioned by data load time). |
| RequireFilter | Boolean | If the value is 'true', queries must include a filter on the partition column to avoid full table scans. If the value is 'false', filters are not mandatory when querying the table. |