github_branchgithub_branch_protectiongithub_commitgithub_community_profilegithub_gistgithub_gitignoregithub_issuegithub_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_teamgithub_organizationgithub_pull_requestgithub_releasegithub_repositorygithub_stargazergithub_taggithub_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 |
|---|---|---|
| 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 without 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 without 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. |