GitHub Pre-built templates

Renta pipeline templates create several related GitHub pipelines in one action. You pick the template and the repositories, and Renta creates one pipeline per report type in the template.

Overview

Each template bundles the report types around one task.

Default settings

Every pipeline a template creates starts with the same values.

1. Fields.
   All fields of the report type are selected. The field list of each type is visible in the Parameters picker of a custom report.
2. Table name.
   A fixed name in the github_{report_type} format: the Commits pipeline writes to the github_commits table.
3. Pipeline name.
   The template name plus the report type, for example GitHub — CI/CD — workflows.
4. Overwrite period.
   Last 1 day.

The repositories, the date range, and the schedule you set on the form apply to every pipeline of the template. The pipelines sync the same way as custom reports of the same report type, as described in the Sync strategy section.

Data relationships

The tables join by identifier columns.

1. Jobs to runs.
   Join github_workflow_jobs with github_workflow_runs by the run_id and id columns.
2. Runs to workflows.
   Join github_workflow_runs with github_workflows by the workflow_id and id columns.
3. Review comments to reviews.
   Join github_review_comments with github_reviews by the pull_request_review_id and id columns.
4. Check runs to commits.
   Join github_commit_check_runs with github_commits by the head_sha and sha columns.
5. Comments to issues and pull requests.
   github_issue_comments carries the issue_url column and github_reviews carries pull_request_url. Join them to the url column of github_issues and github_pull_requests.

The repository behind a row is visible in its URL columns, such as Repository URL or HTML URL. Rely on them to separate data when the pipeline reads several repositories.

Creating with template

Follow these steps on the settings screen of the GitHub pipeline.

1. Select Pre-built templates as the integration type.
2. Select the template in the Templates dropdown.
3. Choose the Repositories.

Set the date range and the schedule as usual. These settings apply to all pipelines of the template.

After you click Create pipeline, the pipelines appear in the Pipelines section under the ETL tab.

Template or custom report

A template is a quick start with every field selected. A custom report gives you full control over the configuration.