steampipe plugin install azuresteampipe 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;

Control examples

HPC Cache accounts should use customer-managed key for encryption

Schema for azure_hpc_cache

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cache_size_gb	bigint		The size of the cache, in GB.
cloud_environment	text		The Azure Cloud Environment.
directory_services_settings	jsonb		Specifies directory services settings of the cache.
encryption_settings	jsonb		Specifies encryption settings of the cache.
health	jsonb		The health of the cache.
id	text		The resource ID of the cache.
identity	jsonb		The identity of the cache, if configured.
mount_addresses	jsonb		Array of IP addresses that can be used by clients mounting the cache.
name	text	=	The name of the cache.
network_settings	jsonb		Specifies network settings of the cache.
provisioning_state	text		ARM provisioning state. Possible values include: 'Succeeded', 'Failed', 'Cancelled', 'Creating', 'Deleting', 'Updating'.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
security_settings	jsonb		Specifies security settings of the cache.
sku_name	text		The SKU for the cache.
subnet	text		Subnet used for the cache.
subscription_id	text		The Azure Subscription ID in which the resource is located.
system_data	jsonb		The system meta data relating to the resource.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The type of the cache.
upgrade_status	jsonb		Upgrade 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