Table: bitbucket_workspace_member - Query Bitbucket Workspace Members using SQL

Bitbucket is a Git-based source code repository hosting service owned by Atlassian. The workspace member in Bitbucket is a user who has been granted access to a workspace. Workspace members can have different roles and permissions based on their level of access.

Table Usage Guide

The bitbucket_workspace_member table provides insights into workspace members within Bitbucket. As a DevOps engineer, explore member-specific details through this table, including roles, permissions, and associated metadata. Utilize it to uncover information about members, such as their roles, the level of access, and the verification of permissions.

Important Notes

You must specify the workspace_slug in the where or join clause (where workspace_slug=, join bitbucket_workspace_member on workspace_slug=) to query this table.

Examples

List members in the workspace

Explore which members are part of a specific workspace, providing an overview of who has access to shared resources and projects. This is particularly useful for workspace administrators to manage access and permissions effectively.

select
  display_name,
  uuid,
  account_id
from
  bitbucket_workspace_member
where
  workspace_slug = 'LalitFort';

select
  display_name,
  uuid,
  account_id
from
  bitbucket_workspace_member
where
  workspace_slug = 'LalitFort';

Schema for bitbucket_workspace_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		Account id of the member.
account_status	text		Status of the user.
created_on	timestamp with time zone		Creation date of the user.
display_name	text		Display name of the member.
is_staff	boolean		Is staff user.
member_type	text		Type of the member.
nickname	text		Account name defined by the owner.
self_link	text		Self link to the member.
title	text		Title of the resource.
uuid	text		The member's immutable id.
workspace_slug	text	=	Slug of the workspace to which this member belongs.

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

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

steampipe_export_bitbucket --config '<your_config>' bitbucket_workspace_member