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
Note
This feature is currently in public preview. Functionality and syntax are subject to change before General Availability.
Lists all graph models in the database, showing the latest version for each model by default.
Permissions
To run this command, the user needs Database viewer permissions.
Syntax
.show graph_models [with (Property = Value [, ...])]
.show graph_models details [with (Property = Value [, ...])]
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| Property | String | ❌ | A property to control which versions to show. See Properties. |
| Value | String | ❌ | The value of the corresponding property. |
Properties
| Name | Type | Required | Description |
|---|---|---|---|
showAll |
Boolean | ❌ | If set to true, returns all versions of every graph model. If set to false or not specified, returns only the latest version of each graph model. |
Returns
Basic output format
When using .show graph_models without the details parameter, the command returns a table with the following columns:
| Column | Type | Description |
|---|---|---|
| Name | String | The name of the graph model. |
| CreationTime | DateTime | The date and time when the graph model was created. |
| Id | Guid | A unique identifier (GUID) for the graph model version. |
Detailed output format
When using .show graph_models details, the command returns a table with the following columns:
| Column | Type | Description |
|---|---|---|
| Name | String | The name of the graph model. |
| CreationTime | DateTime | The date and time when the graph model was created. |
| Id | Guid | A unique identifier (GUID) for the graph model version. |
| SnapshotsCount | Long | The number of snapshots available for this graph model. |
| Model | Dynamic | A JSON object containing the graph model definition and properties. |
| AuthorizedPrincipals | Dynamic | A JSON array of principals authorized to access this graph model. |
| RetentionPolicy | Dynamic | A JSON object defining the retention policy for this graph model. |
Examples
Show the latest version of all graph models
.show graph_models
Output
| Name | CreationTime | Id |
|---|---|---|
| SocialNetwork | 2025-04-23T14:32:18Z | bbbbbbbb-1c1c-2d2d-3e3e-444444444444 |
| ProductRecommendations | 2025-04-15T09:45:12Z | cccccccc-2d2d-3e3e-4f4f-555555555555 |
| NetworkTraffic | 2025-04-12T15:42:18Z | dddddddd-3e3e-4f4f-5a5a-666666666666 |
Show all versions of all graph models
.show graph_models with (showAll = true)
Output
| Name | CreationTime | Id |
|---|---|---|
| SocialNetwork | 2025-03-05T11:23:45Z | eeeeeeee-4f4f-5a5a-6b6b-777777777777 |
| SocialNetwork | 2025-03-28T09:18:32Z | ffffffff-5a5a-6b6b-7c7c-888888888888 |
| SocialNetwork | 2025-04-23T14:32:18Z | bbbbbbbb-1c1c-2d2d-3e3e-444444444444 |
| ProductRecommendations | 2025-03-10T14:25:38Z | aaaaaaaa-6b6b-7c7c-8d8d-999999999999 |
| ProductRecommendations | 2025-04-15T09:45:12Z | cccccccc-2d2d-3e3e-4f4f-555555555555 |
| NetworkTraffic | 2025-03-10T13:24:56Z | aaaaaaaa-0b0b-1c1c-2d2d-333333333333 |
| NetworkTraffic | 2025-03-25T10:15:22Z | bbbbbbbb-1c1c-2d2d-3e3e-444444444444 |
| NetworkTraffic | 2025-04-12T15:42:18Z | dddddddd-3e3e-4f4f-5a5a-666666666666 |
Show detailed information for the latest version of all graph models
.show graph_models details
Output
| Name | CreationTime | Id | SnapshotsCount | Model | AuthorizedPrincipals | RetentionPolicy |
|---|---|---|---|---|---|---|
| SocialNetwork | 2025-04-23T14:32:18Z | bbbbbbbb-1c1c-2d2d-3e3e-444444444444 | 3 | {} | [{"Type":"AAD User", "DisplayName":"Alex Johnson (upn: alex.johnson@contoso.com)", "ObjectId":"aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "FQN":"aaduser=aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| ProductRecommendations | 2025-04-15T09:45:12Z | cccccccc-2d2d-3e3e-4f4f-555555555555 | 2 | {} | [{"Type":"AAD User", "DisplayName":"Maria Garcia (upn: maria.garcia@contoso.com)", "ObjectId":"bbbbbbbb-1111-2222-3333-cccccccccccc", "FQN":"aaduser=bbbbbbbb-1111-2222-3333-cccccccccccc;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| NetworkTraffic | 2025-04-12T15:42:18Z | dddddddd-3e3e-4f4f-5a5a-666666666666 | 3 | {} | [{"Type":"AAD User", "DisplayName":"Sam Wilson (upn: sam.wilson@contoso.com)", "ObjectId":"cccccccc-2222-3333-4444-dddddddddddd", "FQN":"aaduser=cccccccc-2222-3333-4444-dddddddddddd;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
Show detailed information for all versions of all graph models
.show graph_models details with (showAll = true)
Output
| Name | CreationTime | Id | SnapshotsCount | Model | AuthorizedPrincipals | RetentionPolicy |
|---|---|---|---|---|---|---|
| SocialNetwork | 2025-03-05T11:23:45Z | eeeeeeee-4f4f-5a5a-6b6b-777777777777 | 3 | {} | [{"Type":"AAD User", "DisplayName":"Alex Johnson (upn: alex.johnson@contoso.com)", "ObjectId":"aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "FQN":"aaduser=aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| SocialNetwork | 2025-03-28T09:18:32Z | ffffffff-5a5a-6b6b-7c7c-888888888888 | 3 | {} | [{"Type":"AAD User", "DisplayName":"Alex Johnson (upn: alex.johnson@contoso.com)", "ObjectId":"aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "FQN":"aaduser=aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}, {"Type":"AAD Group", "DisplayName":"Data Scientists (upn: data.scientists@contoso.com)", "ObjectId":"dddddddd-3333-4444-5555-eeeeeeeeeeee", "FQN":"aadgroup=dddddddd-3333-4444-5555-eeeeeeeeeeee;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"Read-only access", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| SocialNetwork | 2025-04-23T14:32:18Z | bbbbbbbb-1c1c-2d2d-3e3e-444444444444 | 3 | {} | [{"Type":"AAD User", "DisplayName":"Alex Johnson (upn: alex.johnson@contoso.com)", "ObjectId":"aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb", "FQN":"aaduser=aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}, {"Type":"AAD Group", "DisplayName":"Data Scientists (upn: data.scientists@contoso.com)", "ObjectId":"dddddddd-3333-4444-5555-eeeeeeeeeeee", "FQN":"aadgroup=dddddddd-3333-4444-5555-eeeeeeeeeeee;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"Read-only access", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| ProductRecommendations | 2025-03-10T14:25:38Z | aaaaaaaa-6b6b-7c7c-8d8d-999999999999 | 2 | {} | [{"Type":"AAD User", "DisplayName":"Maria Garcia (upn: maria.garcia@contoso.com)", "ObjectId":"bbbbbbbb-1111-2222-3333-cccccccccccc", "FQN":"aaduser=bbbbbbbb-1111-2222-3333-cccccccccccc;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
| ProductRecommendations | 2025-04-15T09:45:12Z | cccccccc-2d2d-3e3e-4f4f-555555555555 | 2 | {} | [{"Type":"AAD User", "DisplayName":"Maria Garcia (upn: maria.garcia@contoso.com)", "ObjectId":"bbbbbbbb-1111-2222-3333-cccccccccccc", "FQN":"aaduser=bbbbbbbb-1111-2222-3333-cccccccccccc;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}, {"Type":"AAD Service Principal", "DisplayName":"ProductAnalytics App (app: product.analytics@contoso.com)", "ObjectId":"eeeeeeee-4444-5555-6666-ffffffffffff", "FQN":"aadapp=eeeeeeee-4444-5555-6666-ffffffffffff;aaaabbbb-0000-cccc-1111-dddd2222eeee", "Notes":"Automated reporting", "RoleAssignmentIdentifier":"a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1"}] | {"SoftDeletePeriod":"365000.00:00:00"} |
Notes
- By default, this command returns only the latest version of each graph model.
- When using the
showAllparameter set totrue, you can see the complete version history of all graph models in your database. - Use the
detailskeyword to get detailed information about graph models, including the model definition, authorized principals, and retention policy. - The basic output format (without
details) provides a quick overview of available graph models. - The detailed output format (with
details) provides comprehensive information about the graph models, useful for administrative and audit purposes. - The results are ordered alphabetically by graph model name, and then by creation date within each model when showing all versions.