Table: buildkite_user - Query Buildkite Users using SQL

Buildkite is a platform that allows you to run fast, secure, and scalable continuous integration pipelines on your own infrastructure. It provides a way to manage and monitor your build pipelines, with features for parallel testing, real-time updates, and more. A Buildkite User is an individual with a registered account on the Buildkite platform, and can create, manage, or contribute to build pipelines.

Table Usage Guide

The buildkite_user table provides insights into individual user profiles within the Buildkite platform. As a DevOps engineer, you can explore user-specific details through this table, including their email, name, and avatar URL. This can be useful for auditing user activity, managing user permissions, or investigating issues related to specific user accounts.

Examples

Get user info

Explore the details of all users in the Buildkite system to understand their roles and permissions. This can be useful for auditing purposes or to ensure the correct access levels are assigned to each user.

select
  *
from
  buildkite_user

select
  *
from
  buildkite_user

Scopes assigned to the access token for this user

Explore which scopes are assigned to the user's access token in Buildkite, allowing you to understand and manage the permissions and access levels of different users.

select
  jsonb_array_elements_text(scopes) as scope
from
  buildkite_user

select
  json_each.value as scope
from
  buildkite_user,
  json_each(scopes)

Schema for buildkite_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access_token_uuid	text		UUID of the access token for these credentials.
created_at	timestamp with time zone		Time when the user was created.
email	text		Email of the user.
id	text		ID of the user.
member_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the organization.
name	text		Name of the user.
scopes	jsonb		Scopes assigned to the access token for this user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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_user