gitlab_applicationgitlab_branchgitlab_commitgitlab_epicgitlab_groupgitlab_group_access_requestgitlab_group_hookgitlab_group_iterationgitlab_group_membergitlab_group_projectgitlab_group_push_rulegitlab_group_subgroupgitlab_group_variablegitlab_hookgitlab_instance_variablegitlab_issuegitlab_merge_requestgitlab_merge_request_changegitlab_my_eventgitlab_my_issuegitlab_my_projectgitlab_projectgitlab_project_access_requestgitlab_project_container_registrygitlab_project_deploymentgitlab_project_iterationgitlab_project_jobgitlab_project_membergitlab_project_pages_domaingitlab_project_pipelinegitlab_project_pipeline_detailgitlab_project_protected_branchgitlab_project_repositorygitlab_project_repository_filegitlab_project_variablegitlab_settinggitlab_snippetgitlab_usergitlab_user_eventgitlab_version
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_pipelinewhere project_id = 123 and id = 12345;
Schema for gitlab_project_pipeline_detail
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
before_sha | text | ||
committed_at | timestamp with time zone | Timestamp of when the commit used by the pipeline was created. | |
coverage | text | Coverage | |
created_at | timestamp with time zone | Timestamp of when the pipeline was created. | |
duration | bigint | Time in seconds the pipeline took to run. | |
finished_at | timestamp with time zone | Timestamp of when the pipeline finished. | |
id | bigint | = | The ID of the pipeline. |
iid | bigint | The internal ID of the pipeline. | |
project_id | bigint | = | The ID of the project the pipeline was run against - link `gitlab_project.id`. |
queued_duration | bigint | Time in seconds the pipeline was queued awaiting running. | |
ref | text | The reference associated with the pipeline (branch name or tag). | |
sha | text | The commit SHA at which the pipeline was run against. | |
source | text | The source of the pipeline. | |
started_at | timestamp with time zone | Timestamp of when the pipeline started. | |
status | text | The status of the pipeline (success/failed/canceled). | |
tag | boolean | Indicates if the pipeline was triggered by a tag. | |
updated_at | timestamp with time zone | Timestamp of when the pipeline was last updated. | |
user_id | bigint | The ID of the user which triggered the pipeline - link to `gitlab_user.ID`. | |
username | text | The username of the user which triggered the pipeline - link to `gitlab_user.username`. | |
web_url | text | The url to view the pipeline. | |
yaml_errors | text |