Table: fly_organization - Query Fly.io Organizations using SQL

Fly.io Organizations are a set of users and applications that can be managed collectively on the Fly.io platform. They provide a centralized way to manage and control access to applications and resources. Fly.io Organizations help in efficient collaboration, resource sharing, and access control across different users and applications.

Table Usage Guide

The fly_organization table provides insights into organizations within Fly.io. As a DevOps engineer, explore organization-specific details through this table, including members, applications, and associated metadata. Utilize it to uncover information about organization structure, member roles, and the distribution of applications across different organizations.

Examples

Basic info

Explore the basic details of your organization such as its name, unique identifier, type, and billing status. This information can be useful for administrative tasks or tracking billing activities.

select
  name,
  id,
  slug,
  type,
  billing_status
from
  fly_organization;

select
  name,
  id,
  slug,
  type,
  billing_status
from
  fly_organization;

List organizations with no payment method configured

Uncover the details of organizations that have not configured a payment method. This is useful for financial auditing or ensuring all organizations in your network have a valid payment method in place.

select
  name,
  id,
  slug,
  type,
  billing_status
from
  fly_organization
where
  not is_credit_card_saved;

select
  name,
  id,
  slug,
  type,
  billing_status
from
  fly_organization
where
  is_credit_card_saved = 0;

List organizations without SSH certificate

Uncover the details of organizations that lack an SSH certificate, which may indicate a potential security vulnerability. This query is useful for identifying and addressing potential weak points in your organization's security infrastructure.

select
  name,
  id,
  slug,
  type
from
  fly_organization
where
  ssh_certificate is null;

select
  name,
  id,
  slug,
  type
from
  fly_organization
where
  ssh_certificate is null;

Schema for fly_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
active_discount_name	text		Specifies the active discount name.
add_on_sso_link	text		Specifies the addOn SSO link.
billing_status	text		The billing status of the organization.
credit_balance	bigint		The current remaining credit balance of the organization.
credit_balance_formatted	text		The formatted current remaining credit balance of the organization.
id	text		A unique identifier of the organization.
internal_numeric_id	text		The internal numeric ID of the organization.
is_credit_card_saved	boolean		If true, a valid credit card is provided for billing.
name	text		The name of the organization.
remote_builder_image	text		Specifies the remote builder image of the organization.
slug	text	=	The organization slug name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ssh_certificate	text		Specifies the SSH certificate.
trust	text		Specifies the trust level. Possible values are: UNKNOWN, RESTRICTED, BANNED, LOW, HIGH.
type	text		The type of the organization.
viewer_role	text		Indicates who can view the details.

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_organization