ADXTableDetails

Azure Data Explorer table details.

Table attributes

Attribute Value
Resource types microsoft.kusto/clusters
Categories Azure Resources
Solutions LogManagement
Basic log No
Ingestion-time transformation Yes
Sample Queries -

Columns

Column Type Description
_BilledSize real The record size in bytes
CachingPolicy dynamic The table's effective entity caching policy, serialized as JSON
CachingPolicyOrigin string Caching policy origin entity (Table/Database/Cluster)
CorrelationId string The client request ID
DatabaseName string The name of the database
EntityType string The type of the table. Can be Table or MaterializedView
HotExtentCount long The total number of extents in the table, stored in the hot cache
HotExtentSize real The total size of extents (compressed size + index size) in the table, stored in the hot cache (in bytes)
HotOriginalSize long The total original size of data in the table, stored in the hot cache (in bytes)
HotRowCount long The total number of rows in the table, stored in the hot cache
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
MaxExtentsCreationTime datetime The maximum creation time of an extent in the table (or null, if there are no extents)
MinExtentsCreationTime datetime The minimum creation time of an extent in the table (or null, if there are no extents)
OperationName string The name of this operation
_ResourceId string A unique identifier for the resource that the record is associated with
RetentionPolicy dynamic The table's effective entity retention policy, serialized as JSON
RetentionPolicyOrigin string Retention policy origin entity (Table/Database/Cluster)
SourceSystem string The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TableName string The name of the table
TenantId string The Log Analytics workspace ID
TimeGenerated datetime The time (UTC) at which this event was generated.
TotalExtentCount long The total number of extents in the table
TotalExtentSize real The total size of extents (compressed size + index size) in the table (in bytes)
TotalOriginalSize real The total original size of data in the table (in bytes)
TotalRowCount long The total number of rows in the table
Type string The name of the table