turbot/github

GitHub
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

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
artifacts_urltextThe address for artifact GitHub web page.
cancel_urltextThe address for workflow run cancel GitHub web page.
check_suite_urltextThe address for the workflow check suite GitHub web page.
conclusiontextThe conclusion for workflow run.
created_attimestamp with time zoneTime when the workflow run was created.
eventtextThe event for which workflow triggered off.
head_branchtextThe head branch of the workflow run branch.
head_commitjsonbThe head commit details for workflow run.
head_repositoryjsonbThe head repository info for the workflow run.
head_shatextThe head sha of the workflow run.
html_urltextThe address for the organization's GitHub web page.
idbigintThe unque identifier of the workflow run.
jobs_urltextThe address for the workflow job GitHub web page.
logs_urltextThe address for the workflow logs GitHub web page.
node_idtextThe node id of the worflow run.
pull_requestsjsonbThe pull request details for the workflow run.
repositoryjsonbThe repository info for the workflow run.
repository_full_nametextFull name of the repository that specifies the workflow run.
rerun_urltextThe address for workflow rerun GitHub web page.
run_numberbigintThe number of time workflow has run.
statustextThe status of the worflow run.
updated_attimestamp with time zoneTime when the workflow run was updated.
urltextThe address for the workflow run GitHub web page.
workflow_idtextThe workflow id of the worflow run.
workflow_urltextThe address for workflow GitHub web page.