Table: gcp_redis_instance - Query Google Cloud Platform Redis Instances using SQL

Google Cloud Platform's Redis service is a fully managed service that powers applications with low-latency data access. It provides secure and highly available Redis instances while Google handles all the underlying infrastructure for you. Redis instances are ideal for use cases such as caching, session storage, gaming leaderboards, real-time analytics, and queueing.

Table Usage Guide

The gcp_redis_instance table provides insights into Redis Instances within Google Cloud Platform. As a DevOps engineer, you can explore instance-specific details through this table, including the instance's ID, name, region, and current status. Utilize it to monitor and manage your Redis instances, ensuring they are configured correctly and running efficiently.

Examples

Basic info

Explore which Google Cloud Platform (GCP) Redis instances have been created, along with their display names, creation times, locations, memory sizes, and reserved IP ranges. This is useful for gaining insights into your GCP Redis instances' configurations and understanding how your resources are being utilized.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance;

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance;

List instances that have authentication enabled

Discover the segments that have enabled authentication to enhance security measures and maintain data privacy within your GCP Redis instances. This can be particularly useful in identifying potential vulnerabilities and ensuring compliance with best practices.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  auth_enabled;

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  auth_enabled = 1;

List instances created in the last 7 days

Discover the segments that have been newly added within the past week. This is beneficial in monitoring the growth and changes in your database over a short period.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  create_time >= current_timestamp - interval '7 days';

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  create_time >= datetime('now', '-7 days');

List the node details of each instance

Gain insights into the specific details of each instance node in your Google Cloud Redis database, such as the creation time and location. This can be particularly useful for troubleshooting or for optimizing your database's performance and security.

select
  name,
  display_name,
  create_time,
  location_id,
  jsonb_pretty(nodes) as instance_nodes
from
  gcp_redis_instance
where
  name = 'instance-test'
  and location_id = 'europe-west3-c';

select
  name,
  display_name,
  create_time,
  location_id,
  nodes as instance_nodes
from
  gcp_redis_instance
where
  name = 'instance-test'
  and location_id = 'europe-west3-c';

List instances encrypted with customer-managed keys

Discover the segments that utilize customer-managed encryption for their instances. This is useful to assess the security measures and determine areas that might need additional protection.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  customer_managed_key is not null;

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  customer_managed_key is not null;

List instances that have transit mode disabled

Discover the segments where transit mode is disabled in instances. This is particularly useful in identifying potential security risks and ensuring data protection standards are maintained.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  transit_encryption_mode = 2;

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  transit_encryption_mode = 2;

List the maintenance details of instances

Explore the maintenance characteristics of your instances to identify when and how often maintenance is performed, as well as the versions available for maintenance. This can help you manage and plan your maintenance activities more effectively.

select
  name,
  display_name,
  create_time,
  location_id,
  maintenance_policy,
  maintenance_schedule,
  maintenance_version,
  available_maintenance_versions
from
  gcp_redis_instance;

select
  name,
  display_name,
  create_time,
  location_id,
  maintenance_policy,
  maintenance_schedule,
  maintenance_version,
  available_maintenance_versions
from
  gcp_redis_instance;

List instances with direct peering access

Explore which instances have direct peering access in order to better manage your network and ensure secure connections. This can be especially useful for maintaining optimal performance and security in your GCP Redis instances.

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  connect_mode = 1;

select
  name,
  display_name,
  create_time,
  location_id,
  memory_size_gb,
  reserved_ip_range
from
  gcp_redis_instance
where
  connect_mode = 1;

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)" -- gcp

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

steampipe_export_gcp --config '<your_config>' gcp_redis_instance