Add azure_redis_enterprise_cluster and azure_redis_enterprise_database tables

[hakuno]

Description

Currently, there are no dedicated tables for Azure Cache for Redis Enterprise resources (Microsoft.Cache/redisEnterprise).

Querying these resources via the generic azure_resource table yields <null> for the properties column. This happens because the generic Azure Resource Manager (ARM) list API suppresses detailed properties for Redis Enterprise resources to optimize payload size.

To retrieve essential details such as hostName, redisVersion, ports, clustering policies, and database configurations, queries must be made directly against the dedicated Redis Enterprise API (Microsoft.Cache/redisEnterprise and Microsoft.Cache/redisEnterprise/databases).

Impact & Motivation

Users managing enterprise-grade Redis instances cannot query critical metadata (e.g., hostname, SKU, port, eviction policy, clustering policy) via SQL using the Steampipe Azure plugin.

Proof of Concept / Expected Behavior

Generic Table Limitation (azure_resource):

Querying the generic table returns null inside properties:

SELECT name, type, properties FROM azure_resource WHERE type ILIKE 'Microsoft.Cache/redisEnterprise';
-- Output: properties column is <null>

Native Azure CLI / Direct API Output:

Calling the dedicated provider API returns all expected metadata:

az redisenterprise list --output json

Sample Expected Data for Clusters:

• name
• hostName (e.g., cluster.eastus2.redis.azure.net)
• redisVersion
• sku.name (e.g., Balanced_B0)
• resourceGroup

And for child databases (Microsoft.Cache/redisEnterprise/databases):

az redisenterprise database list --cluster-name "<cluster>" --resource-group "<rg>" --output json

Sample Expected Data for Databases:

• port (e.g., 10000)
• clientProtocol (e.g., Encrypted)
• clusteringPolicy (e.g., EnterpriseCluster)
• evictionPolicy (e.g., VolatileLRU)

Proposed Tables

• azure_redis_enterprise_cluster (maps to Microsoft.Cache/redisEnterprise)
• azure_redis_enterprise_database (maps to Microsoft.Cache/redisEnterprise/databases)

References

• Azure SDK for Go / ARM API Docs: Microsoft.Cache redisEnterprise REST API