steampipe plugin install githubsteampipe plugin install github

Table: github_actions_repository_workflow_run

GitHub Actions lets you run workflows when other events happen in your repository. For example, you can run a workflow to automatically add the appropriate labels whenever someone creates a new issue in your repository.

The github_actions_repository_workflow_run table can be used to query information about any organization secret, and you must specify which repository in the where or join clause using the repository_full_name column.

Examples

List workflow runs

select
  *
from
  github_actions_repository_workflow_run
where
  repository_full_name = 'turbot/steampipe';

List failure workflow runs

select
  id,
  event,
  workflow_id,
  conclusion,
  status,
  run_number,
  workflow_url,
  head_commit,
  head_branch
from
    github_actions_repository_workflow_run
where
  repository_full_name = 'turbot/steampipe' and conclusion = 'failure';

List manual workflow runs

select
  id,
  event,
  workflow_id,
  conclusion,
  status,
  run_number,
  workflow_url,
  head_commit,
  head_branch
from
    github_actions_repository_workflow_run
where
  repository_full_name = 'turbot/steampipe' and event = 'workflow_dispatch';

.inspect github_actions_repository_workflow_run

WorkflowRun represents a repository action workflow run

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
artifacts_url	text	The address for artifact GitHub web page.
cancel_url	text	The address for workflow run cancel GitHub web page.
check_suite_url	text	The address for the workflow check suite GitHub web page.
conclusion	text	The conclusion for workflow run.
created_at	timestamp with time zone	Time when the workflow run was created.
event	text	The event for which workflow triggered off.
head_branch	text	The head branch of the workflow run branch.
head_commit	jsonb	The head commit details for workflow run.
head_repository	jsonb	The head repository info for the workflow run.
head_sha	text	The head sha of the workflow run.
html_url	text	The address for the organization's GitHub web page.
id	bigint	The unque identifier of the workflow run.
jobs_url	text	The address for the workflow job GitHub web page.
logs_url	text	The address for the workflow logs GitHub web page.
node_id	text	The node id of the worflow run.
pull_requests	jsonb	The pull request details for the workflow run.
repository	jsonb	The repository info for the workflow run.
repository_full_name	text	Full name of the repository that specifies the workflow run.
rerun_url	text	The address for workflow rerun GitHub web page.
run_number	bigint	The number of time workflow has run.
status	text	The status of the worflow run.
updated_at	timestamp with time zone	Time when the workflow run was updated.
url	text	The address for the workflow run GitHub web page.
workflow_id	text	The workflow id of the worflow run.
workflow_url	text	The address for workflow GitHub web page.

turbot/github

Table: github_actions_repository_workflow_run

Examples

List workflow runs

List failure workflow runs

List manual workflow runs

.inspect github_actions_repository_workflow_run

Steampipe

Resources

Community