turbot/github

steampipe plugin install githubsteampipe plugin install github
On This Page
Get Involved

Table: github_gist

GitHub Gist is a simple way to share snippets and pastes with others. You can query ANY gist that you have access to by specifying its id explicitly in the where clause with where id =. You must specify the id in a where clause or join key to use this table.

To list the gists that you own, use the github_my_gist table.

Examples

Get details about ANY public gist (by id)

select
*
from
github_gist
where
id='633175';

.inspect github_gist

GitHub Gist is a simple way to share snippets and pastes with others.

NameTypeDescription
commentsbigintThe number of comments for the gist.
created_attimestamp without time zoneThe timestamp when the gist was created.
descriptiontextThe gist description.
git_pull_urltextThe https url to pull or clone the gist.
git_push_urltextThe https url to push the gist.
html_urltextThe HTML URL of the gist.
idtextThe unique id of the gist.
node_idtextThe Node ID of the gist.
owner_idbigintThe user id (number) of the gist owner.
owner_logintextThe user login name of the gist owner.
owner_typetextThe type of the gist owner (User or Organization).
publicbooleanIf true, the gist is public, otherwise it is private.
updated_attimestamp without time zoneThe timestamp when the gist was last updated.