Plugins

turbot/github

GitHub
Overview
41Tables
Versions
GitHub
steampipe plugin install githubsteampipe plugin install github
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_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
On This Page
Examples
.inspect
Get Involved
Discuss on Slack

Table: github_release

A release is a package of software, along with release notes and links to binary files, for other people to use.

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

Examples

List releases

select
  name,
  published_at
from
  github_release
where
  repository_full_name = 'turbot/steampipe'
order by
  published_at desc;

Download statistics per release

select
  r.name as release_name,
  r.published_at,
  a ->> 'name' as asset_name,
  a ->> 'download_count' as download_count
from
  github_release as r,
  jsonb_array_elements(assets) as a
where
  r.repository_full_name = 'turbot/steampipe'
  and a ->> 'content_type' in ('application/zip', 'application/gzip')
order by
  r.published_at desc,
  asset_name;

.inspect github_release

GitHub Releases bundle project files for download by users.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
assetsjsonbList of assets contained in the release.
assets_urltextAssets URL for the release.
author_logintextThe login name of the user that created the release.
bodytextText describing the contents of the tag.
created_attimestamp with time zoneTime when the release was created.
draftbooleanTrue if this is a draft (unpublished) release.
html_urltextHTML URL for the release.
idbigintUnique ID of the release.
nametextThe name of the release.
node_idtextNode where GitHub stores this data internally.
prereleasebooleanTrue if this is a prerelease version.
published_attimestamp with time zoneTime when the release was published.
repository_full_nametextFull name of the repository that contains the release.
tag_nametextThe name of the tag the release is associated with.
tarball_urltextTarball URL for the release.
target_commitishtextSpecifies the commitish value that determines where the Git tag is created from. Can be any branch or commit SHA.
upload_urltextUpload URL for the release.
urltextURL of the release.
zipball_urltextZipball URL for the release.