Table: bitbucket_tag - Query Bitbucket Tags using SQL

Bitbucket Tags are reference points in your code, marking specific points in your repository's history. It's a way to capture a point in history that marks a significant event, such as a release. Bitbucket tags make it easier to navigate through the repository, identify current versions, and manage your codebase effectively.

Table Usage Guide

The bitbucket_tag table provides insights into tags within Bitbucket repositories. As a DevOps engineer, explore tag-specific details through this table, including the repository it belongs to, its name, and its associated details. Utilize it to manage and organize your codebase effectively, identify current versions of your application, and navigate through your repository with ease.

Important Notes

You must specify the repository_full_name in the where clause to query this table.

Examples

Get commits by tags

Explore which commits are associated with tags in a specific repository. This can be helpful in understanding the relationship between commits and tags in your Bitbucket workspace, aiding in version control and project management.

select
  name,
  repository_full_name,
  split_part(target -> 'links' ->> 'self', '/commit/', 2) as commit_hash
from
  bitbucket_tag
where
  repository_full_name = 'my-workspace/my-repo';

Error: SQLite does not support split_part function.

Schema for bitbucket_tag

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
heads	jsonb		The repository's full name.
name	text		Name of the ref.
repository_full_name	text	=	The concatenation of the repository owner's username and the slugified name, e.g. "turbot/steampipe-plugin-bitbucket". This is the same string used in Bitbucket URLs.
self_link	text		A link to a resource related to this object.
target	jsonb		Specifies details of target of the tag.
title	text		Title of the resource.
type	text		Type of the Bitbucket resource. It will be always "tag".

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_tag