Table: azuredevops_pipeline - Query Azure DevOps Pipelines using SQL
Azure DevOps Pipelines is a cloud service that you can use to automatically build, test, and deploy your code project to any platform. It helps you catch bugs early in the development process and deploy updates more frequently and with higher quality. It supports continuous integration (CI) and continuous delivery (CD) to constantly and consistently test and build your code and ship it to any target.
Table Usage Guide
The azuredevops_pipeline
table provides insights into pipelines within Azure DevOps. As a DevOps engineer, explore pipeline-specific details through this table, including configurations, status, and associated metadata. Utilize it to uncover information about pipelines, such as those with specific configurations, the status of each pipeline, and the verification of pipeline settings.
Examples
Basic info
Explore which Azure DevOps pipelines are currently active, identifying their unique identifiers and names. This can be particularly useful for project managers and developers to gain insights into the status and revision history of their ongoing projects.
select id, name, configuration_type, project_id, folder, revisionfrom azuredevops_pipeline;
select id, name, configuration_type, project_id, folder, revisionfrom azuredevops_pipeline;
List yaml based pipelines
Explore which Azure DevOps pipelines are based on YAML configurations. This can be useful in identifying pipelines that follow this specific format for potential updates or troubleshooting.
select id, name, configuration_type, project_id, folder, revisionfrom azuredevops_pipelinewhere configuration_type = 'yaml';
select id, name, configuration_type, project_id, folder, revisionfrom azuredevops_pipelinewhere configuration_type = 'yaml';
List pipelines associated with a particular project
Explore which pipelines are associated with a specific project in Azure DevOps. This is useful for managing and organizing project resources efficiently.
select l.id as pipeline_id, l.name as pipeline_name, configuration_type, project_id, folder, l.revisionfrom azuredevops_pipeline as l, azuredevops_project as pwhere l.project_id = p.id and p.name = 'private_project';
select l.id as pipeline_id, l.name as pipeline_name, configuration_type, project_id, folder, l.revisionfrom azuredevops_pipeline as l, azuredevops_project as pwhere l.project_id = p.id and p.name = 'private_project';
Schema for azuredevops_pipeline
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
configuration_type | text | Type of the pipeline configuration. | |
folder | text | Pipeline folder. | |
id | bigint | = | Pipeline ID. |
links | jsonb | The class to represent a collection of REST reference links. | |
name | text | Pipeline name. | |
project_id | text | = | ID of the project this pipeline belongs to. |
revision | text | Revision number. | |
title | text | Title of the resource. | |
url | text | URL of the pipeline. |
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)" -- azuredevops
You can pass the configuration to the command with the --config
argument:
steampipe_export_azuredevops --config '<your_config>' azuredevops_pipeline