ducklake_delete_file

Search Shortcut cmd + k | ctrl + k

Documentation / Specification / Tables

Delete files contain the row ids of rows that are deleted. Each data file will have its own delete file if any deletes are present for this data file.

Column name	Column type
`delete_file_id`	`BIGINT`	Primary key
`table_id`	`BIGINT`
`begin_snapshot`	`BIGINT`
`end_snapshot`	`BIGINT`
`data_file_id`	`BIGINT`
`path`	`VARCHAR`
`path_is_relative`	`BOOLEAN`
`format`	`VARCHAR`
`delete_count`	`BIGINT`
`file_size_bytes`	`BIGINT`
`footer_size`	`BIGINT`
`encryption_key`	`VARCHAR`

delete_file_id is the numeric identifier of the delete file. It is a primary key. delete_file_id is incremented from next_file_id in the ducklake_snapshot table.
table_id refers to a table_id from the ducklake_table table.
begin_snapshot refers to a snapshot_id from the ducklake_snapshot table. The delete file is part of the table starting with this snapshot id.
end_snapshot refers to a snapshot_id from the ducklake_snapshot table. The delete file is part of the table up to but not including this snapshot id. If end_snapshot is NULL, the delete file is currently part of the table.
data_file_id refers to a data_file_id from the ducklake_data_file table.
path is the file name of the delete file, e.g., my_file-deletes.parquet for a relative path.
path_is_relative whether the path is relative to the path of the table (true) or an absolute path (false).
format is the storage format of the delete file. Currently, only parquet is allowed.
delete_count is the number of deletion records in the file.
file_size_bytes is the size of the file in bytes.
footer_size is the size of the file metadata footer, in the case of Parquet the Thrift data. This is an optimization that allows for faster reading of the file.
encryption_key contains the encryption for the file if encryption is enabled.