Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Returns a set that contains the specified materialized view or all materialized views in the database with a detailed summary of each materialized view's properties.
Permissions
You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.
Syntax
.show materialized-view MaterializedViewName details
.show .materialized-views (MaterializedViewName, [, ...n]) details
.show .materialized-views details
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| MaterializedViewName | string |
✔️ | Name of the materialized view. |
Returns
Properties that describe policies or extents refer to the materialized part of the view.
Following is the schema of the output returned:
| Column name | Type | Description |
|---|---|---|
| MaterializedViewName | string |
Name of the materialized view. |
| DatabaseName | string |
Database that the materialized view belongs to. |
| Folder | string |
Folder under which the materialized view is created. |
| DocString | string |
Description assigned to the materialized view. |
| TotalExtents | int |
Total number of extents in the materialized view. |
| TotalExtentSize | double | Total size of extents (compressed size + index size) in the materialized view (in bytes). |
| TotalOriginalSize | double | Total original size of data in the materialized view (in bytes). |
| TotalRowCount | int |
Total number of rows in the materialized view. |
| HotExtents | int |
Total number of extents in the materialized view, stored in the hot cache. |
| HotExtentSize | double | Total size of extents (compressed size + index size) in the materialized view, stored in the hot cache (in bytes). |
| HotOriginalSize | double | Total original size of data in the materialized view, stored in the hot cache (in bytes). |
| HotRowCount | int |
Total number of rows in the materialized view, stored in the hot cache. |
| AuthorizedPrincipals | string |
Materialized view's authorized principals, serialized as JSON. |
| RetentionPolicy | string |
Materialized view's effective* retention policy, serialized as JSON. |
| CachingPolicy | string |
Materialized view's effective* caching policy, serialized as JSON. |
| ShardingPolicy | string |
Materialized view's effective* sharding policy, serialized as JSON. |
| MergePolicy | string |
Materialized view's effective* merge policy, serialized as JSON. |
| MinExtentsCreationTime | datetime |
Minimum creation time of an extent in the materialized view (or null, if there are no extents). |
| MaxExtentsCreationTime | datetime |
Maximum creation time of an extent in the materialized view (or null, if there are no extents). |
* Taking into account policies of parent entities (such as database/cluster/Eventhouse).
Examples
Show details about one materialized view
The following command shows details for materialized view OperationsView:
.show materialized-view OperationsView details
Output
| MaterializedViewName | DatabaseName | Folder | DocString | TotalExtents | TotalExtentSize | TotalOriginalSize | TotalRowCount | HotExtents | HotExtentSize | HotOriginalSize | HotRowCount | AuthorizedPrincipals | RetentionPolicy | CachingPolicy | ShardingPolicy | MergePolicy | MinExtentsCreationTime | MaxExtentsCreationTime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OperationsView | Operations | 1109 | 76588803 | 91553069 | 110125 | 27 | 2635742 | 2929926 | 3162 | [{"Type": "AAD User", "DisplayName": "My Name (upn: alias@fabrikam.com)", "ObjectId": "aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "FQN": "aaduser=aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "Notes": ""}] | { "SoftDeletePeriod": "365.00:00:00", "ContainerRecyclingPeriod": "1.00:00:00", "ExtentsDataSizeLimitInBytes": 0, "OriginalDataSizeLimitInBytes": 0 } | { "DataHotSpan": "4.00:00:00", "IndexHotSpan": "4.00:00:00", "ColumnOverrides": [] } | { "MaxRowCount": 750000, "MaxExtentSizeInMb": 1024, "MaxOriginalSizeInMb": 2048 } | { "RowCountUpperBoundForMerge": 0, "MaxExtentsToMerge": 100, "LoopPeriod": "01:00:00", "MaxRangeInHours": 3, "AllowRebuild": true, "AllowMerge": true } | 2023-02-08 15:30:38.8489786 | 2023-02-14 07:47:28.7660267 |