steampipe plugin install azure

Table: azure_hpc_cache - Query Azure HPC Cache using SQL

Azure HPC Cache is a service within Microsoft Azure that accelerates access to data in Azure Blob Storage for high-performance computing (HPC) applications. It provides a caching layer that allows HPC applications to access data as if it were local, improving performance and reducing latency. Azure HPC Cache is beneficial for workloads that require high-speed access to large datasets, such as genomics, financial risk modeling, and simulation.

Table Usage Guide

The azure_hpc_cache table provides insights into Azure HPC Cache within Azure Storage. As a Data Engineer, explore cache-specific details through this table, including operational details, status, and performance metrics. Utilize it to uncover information about cache utilization, identify potential performance bottlenecks, and monitor cache status for potential issues.

Examples

Basic info

Explore which Azure HPC Cache instances are currently deployed in your environment. This is beneficial in understanding the overall usage and configuration of your Azure HPC Cache resources.

select
id,
name,
type,
provisioning_state,
sku_name
from
azure_hpc_cache;
select
id,
name,
type,
provisioning_state,
sku_name
from
azure_hpc_cache;

List network settings details

This query is used to analyze the network settings for Azure's high-performance cache service. It can help users understand and manage the network configurations for their cache services, including DNS search domains, MTU settings, NTP servers, DNS servers, and utility addresses.

select
id,
name,
network_settings ->> 'DNSSearchDomain' as dns_search_domain,
network_settings -> 'Mtu' as mtu,
network_settings ->> 'NtpServer' as ntp_server,
jsonb_pretty(network_settings -> 'DNSServers') as dns_servers,
jsonb_pretty(network_settings -> 'UtilityAddresses') as utility_addresses
from
azure_hpc_cache;
select
id,
name,
json_extract(network_settings, '$.DNSSearchDomain') as dns_search_domain,
json_extract(network_settings, '$.Mtu') as mtu,
json_extract(network_settings, '$.NtpServer') as ntp_server,
network_settings as dns_servers,
network_settings as utility_addresses
from
azure_hpc_cache;

List encryption settings details

Explore the encryption details of your Azure HPC cache to understand its security settings. This can be useful for assessing the security status of your data and ensuring it meets your organization's requirements.

select
id,
name,
encryption_settings -> 'keyEncryptionKey' ->> 'keyUrl' as key_url,
encryption_settings -> 'keyEncryptionKey' -> 'sourceVault' ->> 'id' as source_vault_id,
network_settings -> 'rotationToLatestKeyVersionEnabled' as rotation_to_latest_key_version_enabled
from
azure_hpc_cache;
select
id,
name,
json_extract(
json_extract(encryption_settings, '$.keyEncryptionKey'),
'$.keyUrl'
) as key_url,
json_extract(
json_extract(
json_extract(encryption_settings, '$.keyEncryptionKey'),
'$.sourceVault'
),
'$.id'
) as source_vault_id,
json_extract(
network_settings,
'$.rotationToLatestKeyVersionEnabled'
) as rotation_to_latest_key_version_enabled
from
azure_hpc_cache;

Schema for azure_hpc_cache

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cache_size_gbbigintThe size of the cache, in GB.
cloud_environmenttextThe Azure Cloud Environment.
directory_services_settingsjsonbSpecifies directory services settings of the cache.
encryption_settingsjsonbSpecifies encryption settings of the cache.
healthjsonbThe health of the cache.
idtextThe resource ID of the cache.
identityjsonbThe identity of the cache, if configured.
mount_addressesjsonbArray of IP addresses that can be used by clients mounting the cache.
nametext=The name of the cache.
network_settingsjsonbSpecifies network settings of the cache.
provisioning_statetextARM provisioning state. Possible values include: 'Succeeded', 'Failed', 'Cancelled', 'Creating', 'Deleting', 'Updating'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
security_settingsjsonbSpecifies security settings of the cache.
sku_nametextThe SKU for the cache.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subnettextSubnet used for the cache.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
system_datajsonbThe system meta data relating to the resource.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the cache.
upgrade_statusjsonbUpgrade status of the cache.

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_hpc_cache