Skip to content

Implement ducklake_table_changes() for queries #10

@shefeek-jinnah

Description

@shefeek-jinnah

Description
Add support for change data capture (CDC) queries via a new ducklake_table_changes() table function. The function returns row-level changes between two snapshots, including INSERT, UPDATE, and DELETE operations. Changes are derived by diffing data and delete files across the specified snapshot range and exposing the resulting rows with an explicit change_type column.

Desired behavior:

SELECT * FROM ducklake_table_changes('main.users', 5, 10);
-- Returns: change_type, snapshot_id, and row data

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions