turbot/digitalocean

steampipe plugin install digitaloceansteampipe plugin install digitalocean

Table: digitalocean_floating_ip

DigitalOcean Floating IPs are publicly-accessible static IP addresses that can be mapped to one of your Droplets. They can be used to create highly available setups or other configurations requiring movable addresses.

Examples

List all Floating IPs

select
ip,
droplet ->> 'name' as droplet_name,
region ->> 'slug' as region_slug
from
digitalocean_floating_ip;

Get a Floating IP by IP

select
ip,
droplet ->> 'name' as droplet_name,
region ->> 'slug' as region_slug
from
digitalocean_floating_ip
where
ip = '161.35.249.180';

List all Floating IPs in New York regions

select
ip,
droplet ->> 'name' as droplet_name,
region ->> 'slug' as region_slug
from
digitalocean_floating_ip
where
region ->> 'slug' like 'ny%';

.inspect digitalocean_floating_ip

DigitalOcean Floating IPs are publicly-accessible static IP addresses that can be mapped to one of your Droplets. They can be used to create highly available setups or other configurations requiring movable addresses.

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
dropletjsonbThe Droplet that the floating IP has been assigned to.
droplet_idbigintID of the Droplet that the floating IP has been assigned to.
ipinetThe public IP address of the floating IP. It also serves as its identifier.
regionjsonbThe region that the floating IP is reserved to.
region_slugtextThe slug of the region that the floating IP is reserved to.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
urntextThe uniform resource name (URN) for the database.