steampipe plugin install theapsgroup/gitlab

Table: gitlab_project_pipeline_detail

The gitlab_project_pipeline_detail table can be used to query detailed information about a specific pipeline instance on a specific project.

However, you must specify a project_id and an id (for the pipeline) in the where or join clause.

Examples

Obtain information for a specific pipeline

select
*
from
gitlab_project_pipeline
where
project_id = 123
and id = 12345;

Schema for gitlab_project_pipeline_detail

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
before_shatext
committed_attimestamp with time zoneTimestamp of when the commit used by the pipeline was created.
coveragetextCoverage
created_attimestamp with time zoneTimestamp of when the pipeline was created.
durationbigintTime in seconds the pipeline took to run.
finished_attimestamp with time zoneTimestamp of when the pipeline finished.
idbigint=The ID of the pipeline.
iidbigintThe internal ID of the pipeline.
project_idbigint=The ID of the project the pipeline was run against - link `gitlab_project.id`.
queued_durationbigintTime in seconds the pipeline was queued awaiting running.
reftextThe reference associated with the pipeline (branch name or tag).
shatextThe commit SHA at which the pipeline was run against.
sourcetextThe source of the pipeline.
started_attimestamp with time zoneTimestamp of when the pipeline started.
statustextThe status of the pipeline (success/failed/canceled).
tagbooleanIndicates if the pipeline was triggered by a tag.
updated_attimestamp with time zoneTimestamp of when the pipeline was last updated.
user_idbigintThe ID of the user which triggered the pipeline - link to `gitlab_user.ID`.
usernametextThe username of the user which triggered the pipeline - link to `gitlab_user.username`.
web_urltextThe url to view the pipeline.
yaml_errorstext