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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cluster_id	text		The cluster ID of the node.
conditions	jsonb		These conditions contain the Node Problem Detector condition.
created_at	timestamp with time zone		The time when the node was created.
error_message	text		The details of the error, if any occured when managing the node.
id	text	=	A unique identifier of the instance.
name	text	=	The user-defined name of the node.
organization	text		The ID of the organization where the node resides.
pool_id	text		The pool ID of the node.
project	text		The ID of the project where the node resides.
provider_id	text		It is prefixed by instance type and location information.
public_ip_v4	text		The public IPv4 address of the node.
public_ip_v6	text		The public IPv6 address of the node.
region	text	=	Specifies the region where the node is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The current status of the node.
tags	jsonb		A list of tags associated with the node.
title	text		Title of the resource.
updated_at	timestamp with time zone		The time when the node was updated.
zone	text		Specifies 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