steampipe plugin install azure

Table: azure_kusto_cluster - Query Azure Kusto Clusters using SQL

Azure Kusto is a big data, interactive analytics platform that enables high-performance data exploration, analysis, and visualization. It offers real-time insights on large volumes of streaming data and is used extensively for log and telemetry analytics. Azure Kusto Clusters are the compute resources for the Kusto Engine, which organizes the data and makes it available for querying.

Table Usage Guide

The azure_kusto_cluster table provides insights into Azure Kusto Clusters within Microsoft Azure. As a data analyst or data engineer, explore details of each cluster through this table, including its configuration, status, and metadata. Utilize it to uncover information about clusters, such as their capacity, performance levels, and the data they hold.

Examples

Basic Info

Explore the key characteristics of your Azure Kusto clusters to better understand their configuration and location details. This can assist in managing resources efficiently and optimizing your data analytics operations.

select
name,
id,
location,
type,
sku_name,
uri
from
azure_kusto_cluster;
select
name,
id,
location,
type,
sku_name,
uri
from
azure_kusto_cluster;

List kusto clusters with standard sku tier

Identify instances where Azure Kusto clusters are operating on a standard SKU tier. This is useful to understand the distribution of your resources and manage costs effectively.

select
name,
id,
type,
sku_name,
sku_tier
from
azure_kusto_cluster
where
sku_tier = 'Standard';
select
name,
id,
type,
sku_name,
sku_tier
from
azure_kusto_cluster
where
sku_tier = 'Standard';

List running kusto clusters

Identify instances where Azure Kusto clusters are currently active. This is useful for monitoring the operational status of your Azure resources and maintaining optimal performance.

select
name,
id,
state
from
azure_kusto_cluster
where
state = 'Running';
select
name,
id,
state
from
azure_kusto_cluster
where
state = 'Running';

List the kusto clusters with system-assigned identity

Explore which Azure Kusto clusters are utilizing a system-assigned identity. This is useful for managing and understanding the security configuration of your Azure resources.

select
name,
id,
state
from
azure_kusto_cluster
where
identity ->> 'type' = 'SystemAssigned';
select
name,
id,
state
from
azure_kusto_cluster
where
json_extract(identity, '$.type') = 'SystemAssigned';

Schema for azure_kusto_cluster

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
data_ingestion_uritextThe cluster data ingestion URI.
enable_disk_encryptionbooleanA boolean value that indicates if the cluster's disks are encrypted.
enable_double_encryptionbooleanA boolean value that indicates if double encryption is enabled.
enable_purgebooleanA boolean value that indicates if the purge operations are enabled.
enable_streaming_ingestbooleanA boolean value that indicates if the streaming ingest is enabled.
engine_typetextThe engine type. Possible values include: 'EngineTypeV2', 'EngineTypeV3'.
etagtextAn ETag of the resource created.
idtextThe resource Id.
identityjsonbThe identity of the cluster, if configured.
key_vault_propertiesjsonbKeyVault properties for the cluster encryption.
language_extensionsjsonbList of the cluster's language extensions.
locationtextSpecifies the name of the region, the resource is created at.
nametext=The name of the resource.
optimized_autoscalejsonbOptimized auto scale definition.
provisioning_statetextThe provisioned state of the resource. Possible values include: 'Running', 'Creating', 'Deleting', 'Succeeded', 'Failed'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sku_capacitybigintSKU capacity of the resource.
sku_nametextSKU name of the resource. Possible values include: 'KC8', 'KC16', 'KS8', 'KS16', 'D13V2', 'D14V2', 'L8', 'L16'.
sku_tiertextSKU tier of the resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextThe state of the resource. Possible values include: 'Creating', 'Deleted', 'Deleting', 'Running', 'Starting', 'Stopped', 'Stopping', 'Unavailable'.
state_reasontextSKU tier of the resource.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
trusted_external_tenantsjsonbThe cluster's external tenants.
typetextType of the resource.
uritextThe cluster URI.
virtual_network_configurationjsonbVirtual network definition of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_kusto_cluster