- Documentation
- Specification
- Introduction
- Data Types
- Queries
- Tables
- DuckDB Extension
- Introduction
- Usage
- Maintenance
- Advanced Features
- FAQ
Documentation
/ DuckDB Extension
/ Advanced Features
Row Lineage
Every row created in DuckLake has a unique row identifier, which can be queried as the rowid virtual column.
This identifier is assigned when a row is first inserted into the system.
The identifier is preserved when the row is moved between files - for example as part of UPDATE and compaction operations.
The rowid column can be used to track whether the addition of files actually introduces new rows into DuckLake, or whether the operation is simply moving files around.
This is used internally in the data change feed to differentiate between update operations and delete + insert operations.