27.10. pga_files_scheduled_for_deletion Metadata Table #

This metadata table contains information about Parquet files associated with snapshots that are marked as expired. These files can now be deleted.

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.

path

VARCHAR

NOT NULL, UNIQUE

The path to the Parquet file, for example, my_file.parquet.

path_is_relative

BOOLEAN

NOT NULL

Specifies whether the path to the Parquet file is relative to the path to the analytical table or absolute.

Possible values:

  • true

  • false

Default value: false.

schedule_start

TIMESTAMPTZ

NOT NULL

The scheduled Parquet file deletion date and time.