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
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_atfrom github_releasewhere 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_countfrom github_release as r, jsonb_array_elements(assets) as awhere 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.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
assets | jsonb | List of assets contained in the release. |
assets_url | text | Assets URL for the release. |
author_login | text | The login name of the user that created the release. |
body | text | Text describing the contents of the tag. |
created_at | timestamp with time zone | Time when the release was created. |
draft | boolean | True if this is a draft (unpublished) release. |
html_url | text | HTML URL for the release. |
id | bigint | Unique ID of the release. |
name | text | The name of the release. |
node_id | text | Node where GitHub stores this data internally. |
prerelease | boolean | True if this is a prerelease version. |
published_at | timestamp with time zone | Time when the release was published. |
repository_full_name | text | Full name of the repository that contains the release. |
tag_name | text | The name of the tag the release is associated with. |
tarball_url | text | Tarball URL for the release. |
target_commitish | text | Specifies the commitish value that determines where the Git tag is created from. Can be any branch or commit SHA. |
upload_url | text | Upload URL for the release. |
url | text | URL of the release. |
zipball_url | text | Zipball URL for the release. |