@lancedb/lancedb • Docs

---

@lancedb/lancedb / MaterializedViewDefinition

Interface: MaterializedViewDefinition

The query that defines a materialized view.

Properties

filter?

optional filter: string;

SQL predicate selecting the source rows the view holds.

---

inputs

inputs: string[];

Source columns the projections and filter read.

---

limit?

optional limit: number;

Cap on the number of rows the view holds.

---

projections

projections: [string, string][];

[output column, SQL expression] pairs, in view schema order.

---

sourceNamespace

sourceNamespace: string[];

Namespace holding the source table; empty is the root namespace.

---

sourceTable

sourceTable: string;

Name of the source table, in the same database as the view.