Table: bitbucket_workspace - Query Bitbucket Workspaces using SQL

Bitbucket Workspaces are a key component of Bitbucket Cloud, providing a shared environment for teams to collaborate on code. Workspaces contain repositories, pull requests, and other resources, and are associated with a team or an individual user account. Each workspace has a unique ID, and can be customized with a name, type, and other metadata.

Table Usage Guide

The bitbucket_workspace table provides insights into Bitbucket Workspaces within Bitbucket Cloud. As a DevOps engineer or a software developer, explore workspace-specific details through this table, including workspace ID, name, type, and associated metadata. Utilize it to manage and monitor workspaces, such as identifying workspaces with specific types, or retrieving workspace metadata for audit or reporting purposes.

Important Notes

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

Examples

Basic info for a workspace

Explore the key characteristics of a specific workspace, such as its name, unique identifier, and privacy status. This is useful for understanding the configuration and accessibility of your workspace within the Bitbucket platform.

select
  name as workspace,
  slug,
  uuid,
  is_private
from
  bitbucket_workspace
where
  slug = 'np1981';

select
  name as workspace,
  slug,
  uuid,
  is_private
from
  bitbucket_workspace
where
  slug = 'np1981';

Schema for bitbucket_workspace

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
is_private	boolean		Indicates whether the workspace is publicly accessible, or whether it is private to the members and consequently only visible to members. Note that private workspaces cannot contain public repositories.
name	text		The name of the workspace.
slug	text	=	The short label that identifies this workspace.
title	text		Title of the resource.
type	text		Type of the Bitbucket resource.
uuid	text		The workspace's immutable id.

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