gitlab_project_pipeline table can be used to query information about pipelines on a specific project.
However, you must specify a
project_id in the where or join clause.
List pipeline information for a project
select*fromgitlab_project_pipelinewhereproject_id = 123;
Pipelines for a GitLab Project
|created_at||timestamp without time zone||Timestamp of when the pipeline was created.|
|id||bigint||The ID of the pipeline.|
|project_id||bigint||The ID of the project the pipeline was run against - link `gitlab_project.id`.|
|ref||text||The reference associated with the pipeline (branch name or tag).|
|sha||text||The commit SHA at which the pipeline was run against.|
|status||text||The status of the pipeline (success/failed/canceled).|
|updated_at||timestamp without time zone||Timestamp of when the pipeline was last updated.|
|web_url||text||The url to view the pipeline.|