Table: linode_region - Query Linode Regions using SQL

A Linode Region represents a geographic location where Linode services are hosted. These regions are data centers that are spread across the world, and each region may have multiple availability zones. Choosing the right region can help reduce latency and increase redundancy for your applications.

Table Usage Guide

The linode_region table provides insights into the geographical distribution of Linode services. As a system administrator or DevOps engineer, you can use this table to explore details about each region, including its location and capabilities. This information can be crucial when planning the deployment of applications, ensuring optimal performance and redundancy.

Examples

List all regions

Discover the segments that allow you to understand the geographical distribution of your Linode resources, helping you manage and optimize your operations based on regional factors.

select
  *
from
  linode_region
order by
  id;

select
  *
from
  linode_region
order by
  id;

List all US regions

Explore all regions within the United States to better understand the geographical distribution of your resources. This can assist in optimizing resource allocation and improving operational efficiency.

select
  *
from
  linode_region
where
  country = 'us'
order by
  id;

select
  *
from
  linode_region
where
  country = 'us'
order by
  id;

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

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

steampipe_export_linode --config '<your_config>' linode_region