.alter materialized-view autoUpdateSchema

2024-08-20

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

Sets the autoUpdateSchema value of an existing materialized view to true or false. For information on the autoUpdateSchema property, see materialized view create command properties.

Permissions

You must have at least Materialized View Admin permissions to run this command.

Syntax

.alter materialized-view MaterializedViewName autoUpdateSchema Boolean

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
MaterializedViewName	`string`	✔️	Name of the materialized view.
Boolean	`bool`	✔️	`autoUpdateSchema` value to be updated.

Returns

Output schema:

Name	Type	Description
Name	`string`	Name of the materialized view.
SourceTable	`string`	Name of source table on which the view is defined.
Query	`string`	Query definition of the materialized view.
MaterializedTo	`datetime`	Maximum materialized ingestion_time() timestamp in source table. For more information, see how materialized views work.
LastRun	`datetime`	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`	Folder under which the materialized view is created.
DocString	`string`	Description assigned to the materialized view.
AutoUpdateSchema	`bool`	Whether the view is enabled for auto updates.
EffectiveDateTime	`datetime`	Effective date time of the view, determined during creation time (see `.create materialized-view`).
Lookback	`timespan`	The time span that limits the period during which duplicates or updates are expected. For more information, see Lookback period.
LookbackColumn	`string`	A `string` column in the view which serves as the reference for the lookback period. If this column is empty, but the `lookback` has a value, then the materialized view uses a default lookback. For more information, see Lookback period.

Examples

Enable auto update schema for a materialized view

The following command enables autoUpdateSchema for materialized view MyView, so that when the schema of the source table on which the view is based changes, the schema of the view is automatically updated to reflect those changes.

.alter materialized-view MyView autoUpdateSchema true

Output

Name	SourceTable	Query	MaterializedTo	LastRun	LastRunResult	IsHealthy	IsEnabled	Folder	DocString	AutoUpdateSchema	EffectiveDateTime	Lookback
MyView	MyTable	summarize take_any(*) by Column1	2023-02-26T16:40:03.3345704Z	2023-02-26T16:44:15.9033667Z	Completed	true	true			true	2023-02-23T14:01:42.5172342Z

Disable auto update schema for a materialized view

The following command disables autoUpdateSchema for materialized view MyView, so that when the schema of the source table on which the view is based changes, the schema of the view doesn't update automatically to reflect those changes.

.alter materialized-view MyView autoUpdateSchema false