Table: scaleway_kubernetes_pool - Query Scaleway Kubernetes Pools using SQL

Scaleway Kubernetes Pools are a feature within Scaleway's Kubernetes Service that allows for the grouping of nodes within a Kubernetes cluster. These pools provide a way to manage the distribution and scaling of workloads across different nodes. Kubernetes Pools are essential for maintaining the performance and reliability of applications running on a Kubernetes cluster.

Table Usage Guide

The scaleway_kubernetes_pool table offers insights into the configuration and status of Kubernetes Pools within Scaleway's Kubernetes Service. As a DevOps engineer or system administrator, you can explore details about each pool, such as its size, autoscaling settings, and associated metadata. Utilize this table to monitor the state of your Kubernetes Pools, identify any potential scaling issues, and ensure optimal distribution of workloads across your Kubernetes cluster.

Examples

Basic info

Explore the status and details of your Kubernetes clusters in Scaleway. This allows you to assess the health and version of your clusters, helping with maintenance and troubleshooting.

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  created_at,
  version
from
  scaleway_kubernetes_pool;

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  created_at,
  version
from
  scaleway_kubernetes_pool;

List kubernetes pools with a specific node type

Determine the areas in which Kubernetes pools are utilizing a specific node type within the Scaleway platform. This can be useful for resource optimization and understanding the distribution of node types across your Kubernetes clusters.

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  created_at,
  version
from
  scaleway_kubernetes_pool
where
  node_type = 'play2_nano';

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  created_at,
  version
from
  scaleway_kubernetes_pool
where
  node_type = 'play2_nano';

List kubernetes pools with auto-scaling disabled

Identify Kubernetes pools where auto-scaling is turned off. This can be useful in managing system resources and preventing unexpected scaling actions.

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  autoscaling,
  version
from
  scaleway_kubernetes_pool
where
  autoscaling is false;

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  autoscaling,
  version
from
  scaleway_kubernetes_pool
where
  autoscaling is 0;

List kubernetes pools with Kubernetes version inferior to 1.24

Determine the areas in which Kubernetes pools are operating on versions older than 1.24. This can help in identifying pools that may need to be updated for security or feature improvements.

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  version
from
  scaleway_kubernetes_pool
where
  version < '1.24';

select
  name,
  node_type,
  cluster_id,
  id,
  status,
  version
from
  scaleway_kubernetes_pool
where
  version < '1.24';

Schema for scaleway_kubernetes_pool

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
autohealing	boolean		The enablement of the autohealing feature for the pool.
autoscaling	boolean		The enablement of the autoscaling feature for the pool.
cluster_id	text		The cluster ID of the pool.
created_at	timestamp with time zone		The time when the pool was created.
id	text	=	A unique identifier of the instance.
kubelet_args	text		The Kubelet arguments to be used by this pool.
max_size	bigint		The maximum size of the pool
min_size	bigint		The minimum size of the pool.
name	text	=	The user-defined name of the pool.
node_type	text		The type of the node.
organization	text		The ID of the organization where the pool resides.
placement_group_id	text		The placement group ID in which all the nodes of the pool will be created.
project	text		The ID of the project where the pool resides.
region	text	=	Specifies the region where the pool is located.
root_volume_size	jsonb		The system volume disk size.
root_volume_type	jsonb		The system volume disk type.
size	bigint		The size (number of nodes) of the pool.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The current status of the pool.
tags	jsonb		A list of tags associated with the pool.
title	text		Title of the resource.
updated_at	timestamp with time zone		The time when the pool was updated.
upgrade_policy	jsonb		The Pool upgrade policy.
version	text		The Kubernetes version of the pool.
zone	text		Specifies the zone where the pool is located.

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

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

steampipe_export_scaleway --config '<your_config>' scaleway_kubernetes_pool