Skip to main content
Applies to: Embedded ❌, Enterprise ✅ A LanceDB extension with no DataFusion equivalent.
A refresh updates the view’s stored result. Refresh views in dependency order, starting with their source views. full = true forces a complete rebuild even when the sources are unchanged; the default, false, refreshes incrementally when supported and rebuilds otherwise.
CASCADE is not accepted by the SQL implementation described here, regardless of what a local SDK’s refresh() method accepts — do not assume the two option sets match.

​
Resource budgets

Enterprise 1.12.0 supports only the full refresh option. It rejects CPU, memory and GPU budget options for materialized-view refreshes.

​
Watching a refresh

A refresh submits work that outlives the call. Track it with SHOW JOBS, and diagnose failures with SHOW ERRORS. For per-split progress, worker fleet detail, and a DESCRIBE JOB example, see Watching a refresh.

​
See also

Materialized View

Creating the view this refreshes.

Refresh a materialized view

The same operation from the SDKs, and automatic refresh.

REFRESH COLUMN

Filling a computed column, instead of a view.