github_actions_artifactgithub_actions_repository_runnergithub_actions_repository_secretgithub_actions_repository_workflow_rungithub_audit_loggithub_branchgithub_branch_protectiongithub_commitgithub_community_profilegithub_gistgithub_gitignoregithub_issuegithub_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_stargithub_my_teamgithub_organizationgithub_organization_membergithub_pull_requestgithub_rate_limitgithub_releasegithub_repositorygithub_search_codegithub_search_commitgithub_search_issuegithub_search_labelgithub_search_pull_requestgithub_search_repositorygithub_search_topicgithub_search_usergithub_stargazergithub_taggithub_teamgithub_team_membergithub_team_repositorygithub_traffic_view_dailygithub_traffic_view_weeklygithub_usergithub_workflow
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_runwhere repository_full_name = 'turbot/steampipe';
List failure workflow runs
select id, event, workflow_id, conclusion, status, run_number, workflow_url, head_commit, head_branchfrom github_actions_repository_workflow_runwhere 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_branchfrom github_actions_repository_workflow_runwhere 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. |