steampipe plugin install azure

Table: azure_redis_cache - Query Azure Redis Cache using SQL

Azure Redis Cache is a fully managed, in-memory cache that enables high-performance and scalable architectures. It uses the popular open-source Redis data structure store, which supports a variety of data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, and more. It's a part of Azure's suite of database services, providing a reliable and secure Redis cache environment.

Table Usage Guide

The azure_redis_cache table provides insights into each Azure Redis Cache resource within your Azure environment. As a database administrator or developer, you can use this table to gain a comprehensive overview of your Redis Cache resources, including their names, locations, associated resource groups, and subscriptions. This information can be instrumental in optimizing your cache usage, managing resources, and planning capacity.

Examples

Basic info

Explore the details of your Azure Redis Cache instances to understand their current status, region, and version. This can help you manage your resources effectively and ensure they are correctly provisioned and operating in the expected regions.

select
name,
redis_version,
provisioning_state,
port,
sku_name,
region,
subscription_id
from
azure_redis_cache;
select
name,
redis_version,
provisioning_state,
port,
sku_name,
region,
subscription_id
from
azure_redis_cache;

List cache servers not using latest TLS protocol

Identify instances where your cache servers are not utilizing the latest TLS protocol. This can be particularly useful for maintaining high security standards and ensuring data protection.

select
name,
region,
resource_group,
minimum_tls_version
from
azure_redis_cache
where
minimum_tls_version is null
or minimum_tls_version <> '1.2';
select
name,
region,
resource_group,
minimum_tls_version
from
azure_redis_cache
where
minimum_tls_version is null
or minimum_tls_version <> '1.2';

List cache servers with in-transit encryption disabled

Explore which cache servers are potentially vulnerable by identifying those with in-transit encryption disabled. This is crucial for enhancing your data security by ensuring all cache servers are encrypted.

select
name,
region,
resource_group,
enable_non_ssl_port
from
azure_redis_cache
where
enable_non_ssl_port;
select
name,
region,
resource_group,
enable_non_ssl_port
from
azure_redis_cache
where
enable_non_ssl_port = 1;

List premium cache servers

Discover the segments that utilize premium cache servers in Azure, enabling you to understand your resource distribution and manage costs effectively. This is particularly useful when assessing your premium services usage across different regions and resource groups.

select
name,
region,
resource_group,
sku_name
from
azure_redis_cache
where
sku_name = 'Premium';
select
name,
region,
resource_group,
sku_name
from
azure_redis_cache
where
sku_name = 'Premium';

Schema for azure_redis_cache

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
access_keysjsonbThe keys of the Redis cache.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
enable_non_ssl_portbooleanSpecifies whether the non-ssl Redis server port (6379) is enabled.
host_nametextSpecifies the name of the redis host.
idtextThe unique id identifying the resource in subscription.
instancesjsonbA list of the Redis instances associated with the cache.
linked_serversjsonbA list of the linked servers associated with the cache.
minimum_tls_versiontextSpecifies the TLS version requires to connect.
nametext=The name of the resource.
portbigintSpecifies the redis non-SSL port.
private_endpoint_connectionsjsonbA list of private endpoint connection associated with the specified redis cache.
provisioning_statetextThe provisioning state of the redis instance at the time the operation was called. Valid values are: 'Creating', 'Deleting', 'Disabled', 'Failed', 'Linking', 'Provisioning', 'RecoveringScaleFailure', 'Scaling', 'Succeeded', 'Unlinking', 'Unprovisioning', and 'Updating'.
public_network_accesstextIndicates whether or not public endpoint access is allowed for this cache. Valid values are: 'Enabled', 'Disabled'.
redis_configurationjsonbDescribes the redis cache configuration.
redis_versiontextSpecifies the version.
regiontextThe Azure region/location in which the resource is located.
replicas_per_masterbigintThe number of replicas to be created per master.
resource_grouptext=The resource group which holds this resource.
shard_countbigintThe number of shards to be created on a premium cluster cache.
sku_capacitybigintThe size of the Redis cache to deploy.
sku_familytextThe SKU family to use.
sku_nametextThe type of Redis cache to deploy.
ssl_portbigintSpecifies the redis SSL port.
static_ipinetSpecifies the statis IP address. Required when deploying a Redis cache inside an existing Azure Virtual Network.
subnet_idtextThe full resource ID of a subnet in a virtual network to deploy the Redis cache in.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
tenant_settingsjsonbA dictionary of tenant settings.
titletextTitle of the resource.
typetextThe type of the resource.
zonesjsonbA list of availability zones denoting where the resource needs to come from.

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_redis_cache