Query: project_failed_pipeline_table

select
  p.full_path as "Project",
  l.id as "Pipeline",
  l.ref as "Pipeline Ref",
  now()::date - l.updated_at::date as "Age in Days",
  p.web_url,
  l.web_url as pipeline_url
from
  gitlab_my_project p
  join gitlab_project_pipeline l on p.id = l.project_id
where
  l.status = 'failed';