Table: digitalocean_region - Query DigitalOcean Regions using SQL
DigitalOcean Regions represent the geographical locations where your Droplets and other resources reside. Each region is a separate geographic area, and each region generally has multiple, isolated locations known as availability zones. Regions are designed to allow users to place resources, like Droplets and Spaces, closer to customers for reduced latency.
Table Usage Guide
The digitalocean_region
table provides insights into the Regions within DigitalOcean. As a DevOps engineer, explore region-specific details through this table, including the slug, name, features, and sizes available in these regions. Utilize it to understand the geographical distribution of your resources and the features available in each region.
Examples
List all regions
Explore the various regions available in your DigitalOcean account. This is useful for planning resource distribution and managing data residency requirements.
select *from digitalocean_region;
select *from digitalocean_region;
New York regions
Explore regions within the DigitalOcean service that are based in New York to better manage resources or optimize network latency for local users.
select *from digitalocean_regionwhere slug like 'ny%';
select *from digitalocean_regionwhere slug like 'ny%';
Regions available for new droplets
Explore which regions are currently available for deploying new droplets on DigitalOcean. This can be helpful for planning deployments and ensuring optimal location selection.
select slug, name, availablefrom digitalocean_regionwhere available;
select slug, name, availablefrom digitalocean_regionwhere available = 1;
Regions where the storage feature is available
Discover the regions where the storage feature is available. This can be useful for understanding where you can deploy resources that require this feature.
select slug, name, featuresfrom digitalocean_regionwhere features ? 'storage';
Error: SQLite does not support the '?' operator for JSON objects.
Schema for digitalocean_region
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
akas | jsonb | Array of globally unique identifier strings (also known as) for the resource. | |
available | boolean | This is a boolean value that represents whether new Droplets can be created in this region. | |
features | jsonb | This attribute is set to an array which contains features available in this region. | |
name | text | The display name of the region. This will be a full name that is used in the control panel and other interfaces. | |
sizes | jsonb | This attribute is set to an array which contains the identifying slugs for the sizes available in this region. | |
slug | text | A human-readable string that is used as a unique identifier for each region. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
tags | jsonb | A map of tags for the resource. | |
title | text | Title of the resource. |