| ms.service | azure |
|---|---|
| ms.topic | include |
| ms.date | 01/12/2026 |
| Name | Type | Description |
|---|---|---|
| backfill | bool |
Whether to create the view based on all records currently in SourceTable (true), or to create it from now on (false). Default is false. For more information, see Backfill a materialized view. |
| effectiveDateTime | datetime |
Relevant only when you're using backfill. If set, the creation only backfills with records ingested after the datetime. backfill must also be set to true. This property expects a datetime literal; for example, effectiveDateTime=datetime(2019-05-01). |
| updateExtentsCreationTime | bool |
Relevant only when you're using backfill. If set to true, Extent Creation time is assigned based on the datetime group-by key during the backfill process. For more information, see Backfill a materialized view. |
| lookback | timespan |
The time span that limits the period during which duplicates or updates are expected. For more information, see Lookback period. |
| lookback_column | 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. |
| autoUpdateSchema | bool |
Whether to automatically update the view on source table changes. Default is false. This option is valid only for views of type arg_max(Timestamp, *)/arg_min(Timestamp, *)/take_any(*) (only when the column's argument is *). If this option is set to true, changes to the source table are automatically reflected in the materialized view. |
| dimensionTables | array | A dynamic argument that includes an array of dimension tables in the view. See Query parameter. |
| folder | string |
The materialized view's folder. |
| docString | string |
A string that documents the materialized view. |
| allowMaterializedViewsWithoutRowLevelSecurity | bool |
Allows creating a materialized view over a table with row level security policy enabled. Only required for views of type arg_min/arg_max/arg_any. See Row level security policy for more information. |