how to get the latest list of parquet and deletion files #105

djouallah · 2025-05-31T08:09:13Z

djouallah
May 31, 2025

what's the simplest way to get the latest list of parquet files and deletion files if any for a particular table

Answered by uwemaurer

like this by table_id

select path from ducklake_data_file where table_id=1

or by table name:

select path from ducklake_data_file join ducklake_table using (table_id) where table_name='test'

uwemaurer · 2025-06-01T06:07:01Z

like this by table_id

select path from ducklake_data_file where table_id=1

or by table name:

select path from ducklake_data_file join ducklake_table using (table_id) where table_name='test'

0 replies