Table: bitbucket_my_workspace - Query Bitbucket Workspaces using SQL

Bitbucket Workspaces are a central location where teams can store and manage their code repositories. They provide a shared space for collaboration, code review, and version control. Workspaces hold repositories for the development team, providing a collaborative environment to manage and track source code changes.

Table Usage Guide

The bitbucket_my_workspace table provides insights into the user's workspace within Bitbucket. As a DevOps engineer, explore workspace-specific details through this table, including the workspace's slug, type, and associated resources. Utilize it to uncover information about your workspace, such as its privacy settings, the owner's details, and the associated repositories.

Examples

Basic info for the Bitbucket workspaces to which you belong

Explore the Bitbucket workspaces you are a part of to understand their privacy settings. This is useful to ensure the correct level of access and security for your workspaces.

select
  name as workspace,
  slug,
  uuid,
  is_private
from
  bitbucket_my_workspace;

select
  name as workspace,
  slug,
  uuid,
  is_private
from
  bitbucket_my_workspace;

Get members details for workspaces you belong

Explore the details of members within your shared workspaces. This can help you understand who else has access to the same resources, providing valuable context for collaboration and access management. Note: Members will be listed for a workspace only if you have access to list them.

select
  u.display_name as member_name,
  u.uuid as user_uuid,
  w.name as workspace,
  u.workspace_slug,
  u.account_id
from
  bitbucket_workspace_member as u,
  bitbucket_my_workspace as w
where
  w.slug = u.workspace_slug
order by
  w.slug;

select
  u.display_name as member_name,
  u.uuid as user_uuid,
  w.name as workspace,
  u.workspace_slug,
  u.account_id
from
  bitbucket_workspace_member as u,
  bitbucket_my_workspace as w
where
  w.slug = u.workspace_slug
order by
  w.slug;

Schema for bitbucket_my_workspace

Name	Type	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_my_workspace