steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_project_job

The gitlab_project_job table can be used to query information about jobs on a specific project.

However, you must specify a project_id in the where or join clause.

Examples

List jobs for a project (adding limit is highly recommended):

select
  *
from
  gitlab_project_job
where
  project_id = '123'
limit
  10;

List jobs where name contains deploy string:

select
  *
from
  gitlab_project_job
where
  project_id = '123'
  and name like '%deploy%'
limit
  10;

Reference

https://docs.gitlab.com/ee/api/jobs.html

Schema for gitlab_project_job

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allow_failure	boolean		Indicates if the job is allowed to fail and allow the pipeline to proceed.
artifacts	jsonb		An array of artifact information
commit_id	text		The ID of the commit.
commit_short_id	text		The short ID of the commit.
created_at	timestamp with time zone		Timestamp of when the job was created.
duration	double precision		Running duration of the job (seconds).
failure_reason	text		The reason for the job's failure (if failed).
finished_at	timestamp with time zone		Timestamp of when the job finished.
id	bigint		The ID of the job.
name	text		The Name of the job.
pipeline_id	bigint		The ID of the pipeline which the jobs belongs to - link `gitlab_pipeline.id`.
pipeline_project_id	bigint		The ID of the project to which the pipeline belongs - link `gitlab_project.id`.
pipeline_ref	text		The ref of the pipeline.
pipeline_sha	text		The sha of the commit the pipeline ran against.
pipeline_status	text		The status of the pipeline.
project_id	bigint	=	The ID of the project the job was run against - link `gitlab_project.id`.
queued_duration	double precision		Duration in seconds the job was queued before running.
ref	text		The reference associated with the pipeline (branch name or tag).
runner_active	boolean		Indicates if the runner is active.
runner_description	text		The description of the runner assigned to the job.
runner_id	bigint		The ID of the runner assigned to the job.
runner_is_shared	boolean		Indicates if the runner is shared.
runner_name	text		The name of the runner assigned to the job.
stage	text		The stage of the job (build/test/staging/production).
started_at	timestamp with time zone		Timestamp of when the job was started.
status	text		The status of the job (success/failed/canceled).
tag	boolean		Indicates if the job was started by a tag.
trace	text		The trace (aka log) of the job.
user_id	bigint		The ID of the user who triggered the job - link to `gitlab_user.ID`.
user_name	text		The display name of the user who triggered the job.
username	text		The username of the user who triggered the job - link to `gitlab_user.username`.
web_url	text		The url to view the job.