github_actions_artifactgithub_actions_repository_runnergithub_actions_repository_secretgithub_actions_repository_workflow_rungithub_audit_loggithub_branchgithub_branch_protectiongithub_code_ownergithub_commitgithub_community_profilegithub_gistgithub_gitignoregithub_issuegithub_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_stargithub_my_teamgithub_organizationgithub_organization_dependabot_alertgithub_organization_membergithub_pull_requestgithub_rate_limitgithub_releasegithub_repositorygithub_repository_dependabot_alertgithub_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_treegithub_usergithub_workflow
Table: github_my_gist
GitHub Gist is a simple way to share snippets and pastes with others. The github_my_gist
table will list only gists that you own.
To query ANY gist that you have access to (including any public gists), use the github_gist
table.
Examples
List your gists
select *from github_my_gist;
List your public gists
select *from github_my_gistwhere public;
Summarize your gists by language.
select file ->> 'language' as language, count(*)from github_my_gist g cross join jsonb_array_elements(g.files) filegroup by languageorder by count desc
.inspect github_my_gist
GitHub Gists owned by you. GitHub Gist is a simple way to share snippets and pastes with others.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
comments | bigint | The number of comments for the gist. |
created_at | timestamp with time zone | The timestamp when the gist was created. |
description | text | The gist description. |
files | jsonb | Files in the gist. |
git_pull_url | text | The https url to pull or clone the gist. |
git_push_url | text | The https url to push the gist. |
html_url | text | The HTML URL of the gist. |
id | text | The unique id of the gist. |
node_id | text | The Node ID of the gist. |
owner_id | bigint | The user id (number) of the gist owner. |
owner_login | text | The user login name of the gist owner. |
owner_type | text | The type of the gist owner (User or Organization). |
public | boolean | If true, the gist is public, otherwise it is private. |
updated_at | timestamp with time zone | The timestamp when the gist was last updated. |