search

duckdb / duckdb_delta

DuckDB extension for Delta Lake
MIT License
140 stars 16 forks source link

Extend DuckDb SQL with timetravel syntax #109

Open Ture2019 opened 1 month ago

Ture2019 commented 1 month ago

A major point of delta tables is to enable timetravel queries. An example:

SELECT *
FROM delta_scan(...)
AS OF '2023-10-23 00:00:00'

This is currently missing.

Important reference: https://docs.databricks.com/en/delta/history.html#delta-time-travel-syntax

samansmink commented 1 month ago

good point! this is definitely on our todo list. Right now the delta kernel does not yet support this (at least not through the FFI)