Table: buildkite_organization - Query Buildkite Organizations using SQL

Buildkite is a platform that helps developers automate their software build and testing processes. The platform's organization resource represents a group of users that have access to a shared set of pipelines. Organizations in Buildkite can have multiple teams and pipelines, and their settings can be configured to meet specific requirements.

Table Usage Guide

The buildkite_organization table provides insights into organizations within Buildkite. As a DevOps engineer, explore organization-specific details through this table, including settings, members, pipelines, and teams. Utilize it to uncover information about organizations, such as their members' access levels, the configuration of their pipelines, and the structure of their teams.

Examples

List all organizations

Explore the different organizations within your system, ordered by their names, to better manage and understand your organizational structure. This can be particularly useful for administrators or managers who need a comprehensive overview of all the organizations they oversee.

select
  slug,
  name,
  id
from
  buildkite_organization
order by
  name;

select
  slug,
  name,
  id
from
  buildkite_organization
order by
  name;

Organizations created in the last week

Explore which organizations have been established in the recent week. This can be useful for keeping track of new additions and assessing the growth rate of your network.

select
  slug,
  name,
  id,
  created_at
from
  buildkite_organization
where
  created_at > now() - interval '7 days'
order by
  created_at desc;

select
  slug,
  name,
  id,
  created_at
from
  buildkite_organization
where
  created_at > datetime('now', '-7 days')
order by
  created_at desc;

Schema for buildkite_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
agents_url	text		Agents URL for the organization.
created_at	timestamp with time zone		Time when the organization was created.
emojis_url	text		Emojis URL for the organization.
graphql_id	text		GraphQL ID for the organization.
id	text		ID of the organization.
member_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the organization.
name	text		Name of the organization.
pipelines_url	text		Pipelines URL for the organization.
repository	text		Repository for the organization.
slug	text	=	Slug of the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
url	text		URL for the organization.
web_url	text		Web URL for the organization.

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

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

steampipe_export_buildkite --config '<your_config>' buildkite_organization