Table: bitbucket_project - Query Bitbucket Projects using SQL

Bitbucket Projects is a feature within Bitbucket that allows users to group repositories into projects, making it easier to manage permissions and collaborate across multiple repositories. Projects provide a way to group repositories that are related to each other, such as those that are part of the same product or application. Projects also allow you to manage access control, so you can specify who has access to which repositories.

Table Usage Guide

The bitbucket_project table provides insights into projects within Bitbucket. As a DevOps engineer or a software developer, explore project-specific details through this table, including project permissions, associated repositories, and other metadata. Utilize it to uncover information about projects, such as those with specific access controls, the associated repositories within each project, and the overall structure of your Bitbucket projects.

Important Notes

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

Examples

Get information about a specific project

Explore the details of a specific project by identifying key attributes such as the project name, unique identifier, workspace slug, owner's display name, and its privacy status. This can be particularly useful for project management and auditing purposes, allowing for a better understanding of project ownership and privacy settings.

select
  name,
  uuid,
  key as project_key,
  workspace_slug,
  owner_display_name,
  is_private
from
  bitbucket_project
where
  workspace_slug = 'np1981';

select
  name,
  uuid,
  key as project_key,
  workspace_slug,
  owner_display_name,
  is_private
from
  bitbucket_project
where
  workspace_slug = 'np1981';

Schema for bitbucket_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		Timestamp when project was last updated.
description	text		A usefule description for thr project.
is_private	boolean		Indicates whether the project is publicly accessible, or whether it is private to the team and consequently only visible to team members. Note that private projects cannot contain public repositories.
key	text	=	The project's key.
name	text		The name of the project.
owner_display_name	text		Display name of the owner of this project.
owner_type	text		Type of the owner of this project.
owner_uuid	text		UUID of the owner of this project.
self_link	text		A self link to this project.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
type	text		Type of the Bitbucket resource.
updated	timestamp with time zone		Timestamp when project was last updated.
uuid	text		The project's immutable id.
workspace_slug	text	=	Slug name of the workspace to which this project 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_project