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_atfrom scaleway_kubernetes_node;
select name, cluster_id, id, status, created_atfrom 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_atfrom scaleway_kubernetes_nodewhere status <> 'ready';
select name, cluster_id, id, status, error_message, created_atfrom scaleway_kubernetes_nodewhere 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_atfrom scaleway_kubernetes_nodewhere public_ip_v6 != '<nil>';
select name, cluster_id, id, status, public_ip_v6, created_atfrom scaleway_kubernetes_nodewhere 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_atfrom scaleway_kubernetes_nodewhere created_at <= now() - interval '90' day;
select name, cluster_id, id, status, updated_at, created_atfrom scaleway_kubernetes_nodewhere created_at <= datetime('now', '-90 day');
Schema for scaleway_kubernetes_node
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. |
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