.show materialized-views commands

The following show commands display information about materialized views.

.show materialized-view

Displays information about the materialized view's definition and its current state.

Syntax

.show materialized-view MaterializedViewName

.show materialized-views

Properties

Property	Type	Description
MaterializedViewName	String	Name of the materialized view.

Example

.show materialized-view ViewName

Output

Output parameter	Type	Description
Name	String	The name of the materialized view.
SourceTable	String	The source table of the materialized view.
Query	String	The materialized view query.
MaterializedTo	datetime	The max materialized ingestion_time() timestamp in source table. For more information, see how materialized views work.
LastRun	datetime	The last time materialization was run.
LastRunResult	String	Result of last run. Returns Completed for successful runs, otherwise Failed.
IsHealthy	bool	True when view is considered healthy, False otherwise. View is considered healthy if it was successfully materialized up to the last hour (MaterializedTo is greater than ago(1h)).
IsEnabled	bool	True when view is enabled (see Disable or enable materialized view).
Folder	string	The materialized view folder.
DocString	string	The materialized view doc string.
AutoUpdateSchema	bool	Whether the view is enabled for auto updates.
EffectiveDateTime	datetime	The effective date time of the view, determined during creation time (see .create materialized-view).

.show materialized-view schema

Returns the schema of the materialized view in CSL/JSON.

Syntax

.show materialized-view MaterializedViewName cslschema

.show materialized-view MaterializedViewName schema as json

.show materialized-view MaterializedViewName schema as csl

Output parameters

Output parameter	Type	Description
TableName	String	The name of the materialized view.
Schema	String	The materialized view csl schema
DatabaseName	String	The database to which the materialized view belongs
Folder	String	Materialized view's folder
DocString	String	Materialized view's docstring

.show materialized-view extents

Returns the extents in the materialized part of the materialized view. For a definition of the materialized portion, see how materialized views work.

This command provides the same details as the show table extents command.

Syntax

.show materialized-view MaterializedViewName extents [hot]

.show materialized-view failures

Returns failures that occurred as part of the materialization process of the materialized view.

Syntax

.show materialized-view MaterializedViewName failures

Properties

Property	Type	Description
MaterializedViewName	String	Name of the Materialized View.

Output

Output parameter	Type	Description
Name	Timestamp	Failure timestamp.
OperationId	String	The operation ID of the run that failed.
Name	String	The materialized view name.
LastSuccessRun	datetime	The timestamp of the last run that completed successfully.
FailureKind	String	Type of failure.
Details	String	Failure details.