Table: fly_location - Query Fly Locations using SQL

Fly Locations refers to the geographical locations where Fly.io applications are deployed. Fly.io provides a platform for building and running applications close to users, with a global application network that enables developers to run their code anywhere. The locations represent the regions where these applications are running, providing insights into the distribution and reach of the applications.

Table Usage Guide

The fly_location table provides insights into the geographical deployment of applications on Fly.io. As a DevOps engineer, explore location-specific details through this table, including region codes, names, and associated metadata. Utilize it to understand the geographical distribution of your applications, helping in making informed decisions about scaling and resource allocation.

Examples

Basic info

Explore the geographical details of flight locations, such as name, title, and locality, to gain a better understanding of your flight data and make informed decisions about travel routes and destinations.

select
  name,
  title,
  locality,
  state,
  country
from
  fly_location;

select
  name,
  title,
  locality,
  state,
  country
from
  fly_location;

List all available location in a specific country

Discover the segments that are available within a specific country. This can be useful for pinpointing locations for potential business expansion or understanding demographic distribution.

select
  title,
  locality,
  state,
  coordinates
from
  fly_location
where
  country = 'India';

select
  title,
  locality,
  state,
  coordinates
from
  fly_location
where
  country = 'India';

Get count of Fly data centers per country

Analyze the distribution of Fly data centers across different countries. This is useful for understanding where resources are concentrated and can inform decisions about where to deploy additional infrastructure.

select
  country,
  count(name)
from
  fly_location
group by
  country;

select
  country,
  count(name)
from
  fly_location
group by
  country;

Schema for fly_location

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
coordinates	jsonb		Specifies the latitude and longitude of the location.
country	text		Specifies the country name.
locality	text		Specifies the locality.
name	text		The name of the location.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The state of the location.
title	text		Specifies the title.

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

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

steampipe_export_fly --config '<your_config>' fly_location