38.16. pga_partition_value #

This metadata table maps Parquet files to partitions of analytical tables. For more information about partitioning, refer to Chapter 30.

Column Name

Column Type

Constraint

Description

data_file_id

BIGINT

Primary key, foreign key

The ID of the Parquet file from the pga_data_file metadata table.

table_id

BIGINT

Foreign key, NOT NULL

The ID of the analytical table that contains the Parquet file, from the pga_table metadata table.

partition_key_index

BIGINT

NOT NULL

The partition_key_index value from the pga_partition_column metadata table.

partition_value

VARCHAR

NOT NULL

The value of the partition column identified by the partition_key_index value.

All rows in the Parquet file have the same value for the column.