Class: MaterializedView¶

A handle on a materialized view: its table plus its definition.

Obtained from Connection#createMaterializedView or Connection#openMaterializedView. The view is a normal table -- queries, indexes and search all apply through MaterializedView#table -- whose contents are maintained by MaterializedView#refresh.

Constructors¶

new MaterializedView()¶

new MaterializedView(table): MaterializedView

Parameters¶

table: Table

Returns¶

MaterializedView

Accessors¶

name¶

get name(): string

Returns¶

string

Methods¶

definition()¶

definition(): Promise<MaterializedViewDefinition>

The query that defines the view.

Returns¶

Promise<MaterializedViewDefinition>

refresh()¶

refresh(options?): Promise<RefreshMaterializedViewResult>

Recompute the view from its source.

Every refresh rebuilds the complete view. For local views, sourceVersion refreshes to that source version instead of the latest; remote SQL refreshes do not support source-version pinning.

Parameters¶

options?
options.sourceVersion?: number

Returns¶

Promise<RefreshMaterializedViewResult>

table()¶

table(): Table

The view, as the table it is.

Returns¶

Table