steampipe plugin install hcloud

Table: hcloud_datacenter - Query Hetzner Cloud Datacenters using SQL

Hetzner Cloud Datacenters are physical locations around the world where Hetzner Cloud servers reside. They are designed to be highly reliable, secure, and efficient. These datacenters contain the server types and their availability, which are crucial for planning and managing cloud resources.

Table Usage Guide

The hcloud_datacenter table provides insights into datacenters within Hetzner Cloud. As a system administrator or DevOps engineer, explore datacenter-specific details through this table, including location, server types, and availability. Utilize it to uncover information about datacenters, such as their geographical distribution, the types of servers available, and their current availability status.

Examples

List all data centers

Explore the various data centers available, ordered by their names, to better manage resources and optimize performance. This can be particularly useful when planning the deployment of new services or assessing existing infrastructure.

select
*
from
hcloud_datacenter
order by
name;
select
*
from
hcloud_datacenter
order by
name;

Get data center by name

Explore which specific data center is associated with a certain name, allowing you to quickly identify and access relevant data center information for further analysis or management tasks. This is particularly useful in environments with multiple data centers, where locating specific ones by name can streamline administrative tasks.

select
*
from
hcloud_datacenter
where
name = 'hel1';
select
*
from
hcloud_datacenter
where
name = 'hel1';

Get all available server types for all data centers

Explore the variety of server types across all data centers. This is useful for understanding the diverse server options available for different data center deployments, aiding in strategic decision-making and resource allocation.

select
dc.name,
st.*
from
hcloud_datacenter as dc,
jsonb_array_elements(dc.server_types_available) as sta,
hcloud_server_type as st
where
sta :: int = st.id;
select
dc.name,
st.*
from
hcloud_datacenter as dc,
json_each(dc.server_types_available) as sta,
hcloud_server_type as st
where
cast(sta.value as integer) = st.id;

Schema for hcloud_datacenter

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
descriptiontextDescription of the Data Center.
idbigint=ID of the Data Center.
location_idbigintLocation of the Data Center.
nametext=Unique identifier of the Data Center.
server_types_availablejsonbIDs of the server types available at the Data Center.
server_types_supportedjsonbIDs of the server types supported at the Data Center.

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

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

steampipe_export_hcloud --config '<your_config>' hcloud_datacenter