turbot/scaleway
steampipe plugin install scaleway

Table: scaleway_kubernetes_node - Query Scaleway Kubernetes Nodes using SQL

Scaleway Kubernetes Nodes are the worker machines in a Kubernetes cluster that run containerized applications. Each node contains the necessary services to run Pods (the smallest and simplest unit in the Kubernetes object model that you create or deploy), including the container runtime, kubelet, and the kube-proxy. Nodes can be a virtual or physical machine, depending on the cluster.

Table Usage Guide

The scaleway_kubernetes_node table provides insights into Kubernetes Nodes within Scaleway. As a DevOps engineer, explore node-specific details through this table, including status, versions, and associated metadata. Utilize it to uncover information about nodes, such as their health status, the Kubernetes version they are running, and their associated roles and labels.

Examples

Basic info

Analyze the status and creation date of your Scaleway Kubernetes nodes to understand their current operational state and longevity. This can be useful in assessing the overall health and maintenance needs of your Kubernetes infrastructure.

select
name,
cluster_id,
id,
status,
created_at
from
scaleway_kubernetes_node;
select
name,
cluster_id,
id,
status,
created_at
from
scaleway_kubernetes_node;

List kubernetes nodes where status is not ready

Identify Kubernetes nodes that are not in a 'ready' status. This query is useful in pinpointing potential issues within your Kubernetes cluster that may need attention or troubleshooting.

select
name,
cluster_id,
id,
status,
error_message,
created_at
from
scaleway_kubernetes_node
where
status <> 'ready';
select
name,
cluster_id,
id,
status,
error_message,
created_at
from
scaleway_kubernetes_node
where
status <> 'ready';

List kubernetes nodes with ipv6 public

Analyze the settings to understand the status and creation date of Kubernetes nodes on Scaleway that are utilizing IPv6 public IP addresses. This is useful for maintaining network configurations and ensuring optimal performance.

select
name,
cluster_id,
id,
status,
public_ip_v6,
created_at
from
scaleway_kubernetes_node
where
public_ip_v6 != '<nil>';
select
name,
cluster_id,
id,
status,
public_ip_v6,
created_at
from
scaleway_kubernetes_node
where
public_ip_v6 != '<nil>';

List kubernetes nodes created more than 90 days ago

Identify instances where Kubernetes nodes have been active for a prolonged period of time, specifically more than 90 days. This can be useful in managing resources and ensuring optimal performance within your system.

select
name,
cluster_id,
id,
status,
updated_at,
created_at
from
scaleway_kubernetes_node
where
created_at <= now() - interval '90' day;
select
name,
cluster_id,
id,
status,
updated_at,
created_at
from
scaleway_kubernetes_node
where
created_at <= datetime('now', '-90 day');

Schema for scaleway_kubernetes_node

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
cluster_idtextThe cluster ID of the node.
conditionsjsonbThese conditions contain the Node Problem Detector condition.
created_attimestamp with time zoneThe time when the node was created.
error_messagetextThe details of the error, if any occured when managing the node.
idtext=A unique identifier of the instance.
nametext=The user-defined name of the node.
organizationtextThe ID of the organization where the node resides.
pool_idtextThe pool ID of the node.
projecttextThe ID of the project where the node resides.
provider_idtextIt is prefixed by instance type and location information.
public_ip_v4textThe public IPv4 address of the node.
public_ip_v6textThe public IPv6 address of the node.
regiontext=Specifies the region where the node is located.
statustextThe current status of the node.
tagsjsonbA list of tags associated with the node.
titletextTitle of the resource.
updated_attimestamp with time zoneThe time when the node was updated.
zonetextSpecifies the zone where the node 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_node