Duckle v0.5.1 adds dives and dashboards, column lineage, record-level error tracebacks, and a batch of loading, correctness, and UI improvements.
Dives and dashboards
- Local-first, live-querying, shareable data views: each re-runs its SQL on open, so it is never stale.
- Multi-chart dashboards: several dives on one page.
- Generate a chart from a plain-language question.
- Self-contained HTML export, plus standalone /dive/ and /dash/ share pages.
- A top-bar Dives gallery to find and open them.
Visibility and debugging
- Column lineage: a top-bar Lineage view traces each output column back to the source column(s) it derives from, per node.
- Record-level error traceback: every failed stage reports the exact compiled SQL plus the DuckDB message, in the Run view and the NDJSON run log, so any component's failure is debuggable.
Loading and correctness
- DB-sink dead-letter (validate-before-insert): rows that do not match the declared column types are split to a dead-letter file (parquet/csv/json) and only clean rows are inserted.
- src.json: a "skip malformed records" toggle and a working Format selector (auto / array / JSON Lines / object).
- CSV: ignoreErrors and nullPadding toggles in the GUI.
- Raw SQL mode for SQL nodes: run verbatim SQL (a leading WITH, multiple CTEs, UNIONs) with no input-CTE wrapper.
- Excel-native serial dates: set a date/timestamp column's format to "excel" to convert Excel day-serials correctly.
UI and security
- Resizable properties panel, node-label tooltip, always-reachable data-preview scrollbar, clearer per-stage memory-limit guidance.
- The self-hosted web editor now rejects cross-origin and DNS-rebind requests on its state-changing routes.
Pick the binary for your OS below. Available for Windows, macOS (Apple Silicon and Intel), and Linux.