Gist Data Model
In the Gist Data Model, the provider models gists associated with the authenticated account—including their files, comments, forks, and commits—as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the provider. Note that Gists are not available with Enterprise Managed Users.
Tables
The Tables section, which details standard SQL tables, contains samples of what you might have access to in your GitHub account.
The following tables are shipped with the provider:
| Name | Description |
| Comments | Lists comments on gists. |
| Files | Lists up to three hundred files for each gist at their most recent revisions, including up to one megabyte of content per file. |
| Gists | Lists gists at their most recent revisions. |
| Parents | Lists parent gist information for forked gists. |
| Starred | Lists starred gists for the authenticated user. |
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your GitHub account.
The following views are shipped with the provider:
| Name | Description |
| CommentEdits | Lists edit history for gist comments. |
| CommitFiles | Lists up to three hundred files for each gist at every revision, including up to one megabyte of content per file. |
| Commits | Lists the commit history of gists. |
| Forks | Lists gist forks. |
| Stargazers | Lists information about the users who have starred gists. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including getting the currently authenticated user or retrieving and refreshing OAuth access tokens.
The following procedures are shipped with the provider:
| Name | Description |
| DownloadFile | Download a file from a gist. |
| IsGistStarred | Checks if a gist is starred by the authenticated user. |